NEW install of ANY nuke site=same error

Regular Joined: Nov 11, 2003 Posts: 61

i can upload any version of nuke on my site and itll load fine the default admin message will appear but no blocks will appear and when i go to admin panel then to modules i get no modules in the list but get this error..

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/the180th/public_html/includes/sql_layer.php on line 286

doesnt mater what version of nuke i put on the site this is the same error every time

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

Have you installed the database and all the tables?

Posted: Thu Dec 30, 2004 3:23 pm

indeed i have....the site comes up but see no blocks and the modules have that error..

www.180th.com

Posted: Thu Dec 30, 2004 3:24 pm

Turn $debug On in includes/sql_layer.php and you should see what table is in error.

Posted: Thu Dec 30, 2004 3:28 pm

SQL query: select mid from nuke_modules where title='Addon_Sample'
SQL query: select mid from nuke_modules where title='AvantGo'
SQL query: select mid from nuke_modules where title='Content'
SQL query: select mid from nuke_modules where title='Downloads'
SQL query: select mid from nuke_modules where title='Encyclopedia'
SQL query: select mid from nuke_modules where title='FAQ'
SQL query: select mid from nuke_modules where title='Feedback'
SQL query: select mid from nuke_modules where title='Forums'
SQL query: select mid from nuke_modules where title='Journal'
SQL query: select mid from nuke_modules where title='Members_List'
SQL query: select mid from nuke_modules where title='News'
SQL query: select mid from nuke_modules where title='Private_Messages'
SQL query: select mid from nuke_modules where title='Recommend_Us'
SQL query: select mid from nuke_modules where title='Reviews'
SQL query: select mid from nuke_modules where title='Search'
SQL query: select mid from nuke_modules where title='Sections'
SQL query: select mid from nuke_modules where title='Statistics'
SQL query: select mid from nuke_modules where title='Stories_Archive'
SQL query: select mid from nuke_modules where title='Submit_News'
SQL query: select mid from nuke_modules where title='Surveys'
SQL query: select mid from nuke_modules where title='Top'
SQL query: select mid from nuke_modules where title='Topics'
SQL query: select mid from nuke_modules where title='WebMail'
SQL query: select mid from nuke_modules where title='Web_Links'
SQL query: select mid from nuke_modules where title='Your_Account'
SQL query: select title from nuke_modules

im guessing that it didnt create these tables so...do i add these table by hande?

Posted: Thu Dec 30, 2004 3:48 pm

nevermind i added another table that was missing now they are showing up in the modules admin but still not getting ANY blocks showing up

Posted: Thu Dec 30, 2004 3:54 pm

Compare the tables in nuke.sql with the tables in your database

Posted: Thu Dec 30, 2004 8:27 pm

didnt see anything wrong...i maybe missing something...

any clue on why its not creating the tables?