Page 1 of 1
SQL install help
Posted: Tue Nov 14, 2006 5:19 pm
by carolan78
Hello apologies in advance as I am a sql begginer. I have tried installing the quiz mod 1.3 using easymod. Had no problems with that but I can't install the sql file I am trying to install it via phpadmin and I get the following erro any help would be apprieciated cos I have searched the web for about 4 hours now and its all gone totally over my head.
Code: Select all
Error
SQL query:
define(
'IN_PHPBB', true
);
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'define('IN_PHPBB', true)' at line 1
Posted: Wed Nov 15, 2006 4:35 am
by battye
You are supposed to run quiz_install.php in your browser, not in phpMyAdmin.
Basically, this is because most of that file is PHP code
ie.
That is PHP, not SQL.
Posted: Wed Nov 15, 2006 5:24 pm
by carolan78
Hello I tried doing that first but it just opened to this
Code: Select all
Warning: main(./extension.inc) [function.main]: failed to open stream: No such file or directory in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 26
Warning: main(./extension.inc) [function.main]: failed to open stream: No such file or directory in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 26
Warning: main() [function.include]: Failed opening './extension.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 26
Warning: main(./common.) [function.main]: failed to open stream: No such file or directory in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 27
Warning: main(./common.) [function.main]: failed to open stream: No such file or directory in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 27
Warning: main() [function.include]: Failed opening './common.' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 27
Fatal error: Call to undefined function: session_pagestart() in /home/babyvill/public_html/LuciesForum/admin/mods/Ultimate_Quiz_MOD_v133/install/quiz_install.php on line 29
I have this on a test forum going to uninstall and try again.
Posted: Fri Nov 17, 2006 1:09 pm
by battye
Run the file from the root (the area with posting.php, index.php, viewtopic.php etc), not in all of those subfolders