PhotoPost Community - View Single Post

RedPoptarts · January 7th, 2005, 12:54 AM

I've searched for this problem and have found no similar posts, so here goes...

I'm running UBB.Threads v6 and I'm trying to install a fresh installation, but the install.php runs into SQL problems along the way (errors only show at the top, but do not prevent installation from progressing). After I finish installing, my users database is not integrated and I cannot log in. I'm assuming the SQL errors are causing it.

Upon finishing Step 4, I get my first error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sbawpic/public_html/photopost/forums/threads.php on line 397
This seems to be where the SQL tables are created. After this step, I have 2 user tables, one is pp_users and the other is w3t_Users (note the difference in CaSes). On page 4 I specify that my Threads tables use the prefix "w3t_", so I would expect that to allow the integration of the 'users' tables. Again, maybe the SQL error is to blame?

On step 5, all defaut settings are correct, so I continue.

I proceed to try to login for the first time and recieve the following SQL error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sbawpic/public_html/photopost/forums/threads.php on line 31

So basically, I'm getting SQL errors, and then my tables aren't being integrated, plus tables like usergroups are empty (which I would think would extract settings from Threads).

I really have no idea where to begin.

January 7th, 2005, 12:54 AM	#1 (permalink)
RedPoptarts Junior Member Verified Customer Join Date: Jan 2005 Posts: 16	Clean Installation Problems with Threads I've searched for this problem and have found no similar posts, so here goes... I'm running UBB.Threads v6 and I'm trying to install a fresh installation, but the install.php runs into SQL problems along the way (errors only show at the top, but do not prevent installation from progressing). After I finish installing, my users database is not integrated and I cannot log in. I'm assuming the SQL errors are causing it. Upon finishing Step 4, I get my first error: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sbawpic/public_html/photopost/forums/threads.php on line 397 This seems to be where the SQL tables are created. After this step, I have 2 user tables, one is pp_users and the other is w3t_Users (note the difference in CaSes). On page 4 I specify that my Threads tables use the prefix "w3t_", so I would expect that to allow the integration of the 'users' tables. Again, maybe the SQL error is to blame? On step 5, all defaut settings are correct, so I continue. I proceed to try to login for the first time and recieve the following SQL error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sbawpic/public_html/photopost/forums/threads.php on line 31 So basically, I'm getting SQL errors, and then my tables aren't being integrated, plus tables like usergroups are empty (which I would think would extract settings from Threads). I really have no idea where to begin.