PDA

View Full Version : [BUG?] Survey Results don't work


Go2Networks
12-03-2003, 03:40 PM
Fresh install, Fresh DB


Database error in PHP Live Helper: Invalid SQL: SELECT * FROM survey_results order by entry desc LIMIT 0,1

mysql error: Table 'livehelper.survey_results' doesn't exist
mysql error number: 1146
Date: Wednesday 03rd of December 2003 11:03:14 AM
Script: /livehelper/survey.php
TurnkeyAdmin
12-03-2003, 04:36 PM
No they work. We are using them on our site. You must be missing the table? Did you run the upgrade or install from scratch? Also are you using a prefix or no.
Go2Networks
12-03-2003, 05:22 PM
Used the install.php and yes using a prefix.
TurnkeyAdmin
12-03-2003, 11:36 PM
Redownload and just replace the survey.php.
NetPublicist
12-09-2003, 11:26 AM
I get the same error when I try to fill out the survey after chatting, I get this error in the source:

<!-- Database error in PHP Live Helper: Invalid SQL: SELECT * FROM survey_results order by entry desc LIMIT 0,1
mysql error: Table 'netpubli_livehelp.survey_results' doesn't exist
mysql error number: 1146
Date: Tuesday 09th of December 2003 01:25:06 PM
Script: /phplivehelper/survey.php
Referer: http://www.netpublicist.com/phplivehelper/survey.php?PHPSESSID=541728a3e8a2546a38d2b48af01be e5c&admino=NetPublicist
-->
TurnkeyAdmin
12-09-2003, 11:55 AM
Looks like you have a pre RC2 survey.php. Try redownloading it.