PHP-Nuke 7.8 Install Problems with SQL Upload/MySQL Problems

New Member Joined: Mar 17, 2005 Posts: 2

Sup everyone! I just recently donated PHP-Nuke 7.8 to Raven. I am having quite a problem tho. I have given all privledges to the SQL DB user and set the password along with a SQL DB name for MySQL DB. My config.php is setup 100% correctly. The user has FULL priviledges. When i go to upload the SQL text file through phpmyadmin, i get a syntax error for this table:
CREATE TABLE nuke_bbsearch_wordlist. so, therefore, when i got to view my site, it says it has a problem connecting to the SQL DB.. I contacted FB and he gave me an idea to change the table info to the following:

CREATE TABLE nuke_bbsearch_wordlist(
word_text varchar( 50 ) NOT NULL default '',
word_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
word_common tinyint( 1 ) unsigned NOT NULL default '0',
PRIMARY KEY ( word_text ) ,
KEY word_id( word_id )
);

this did work, as far as getting no errors when uploading the SQL DB thu phpmyadmin, but I still get the same problem with my site displaying that their is "a problem with the SQL server, please try again soon" and blah blah... i am running the MOST up-to-date MySQL and phpmyadmin.... any suggestions??? or has anyone had this same problem??? email me at papa_____doc@hotmail.com . THANKS!!

- PHP PAPA DOC

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

See http://www.ravenphpscripts.com/postt5668.html