Not for official support
We do not provide technical support in this forum.
If you want to contact our customer support, please use our support form.

You are not logged in.

#1 2011-04-11 13:19

wei
Member

First Login Error for Shop-Script

I just installed Shop-Script but when I tried to login for the first time, I get the following error -

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/itgadget/public_html/system/updates/update278.php on line 23

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/itgadget/public_html/system/updates/update286.php on line 164

Fatal error: Uncaught exception 'MySQLException' with message 'Query Error Query: SELECT U.U_ID, U.U_PASSWORD, U.U_STATUS, C.* FROM WBS_USER U LEFT JOIN CONTACT C ON U.C_ID = C.C_ID WHERE U_ID = 'ADMINISTRATOR' Error: 1146 Message: Table 'itgadget_shop.WBS_USER' doesn't exist' in /home/itgadget/public_html/system/lib/model/DbModel.class.php:97 Stack trace: #0 /home/itgadget/public_html/system/lib/model/DbModel.class.php(164): DbModel->run('SELECT U.U_ID, ...', false) #1 /home/itgadget/public_html/system/lib/model/DbStatement.class.php(209): DbModel->query('SELECT U.U_ID, ...') #2 /home/itgadget/public_html/system/lib/model/Users.model.php(23): DbStatement->query(Array) #3 /home/itgadget/public_html/system/lib/entity/User.class.php(129): UsersModel->get('ADMINISTRATOR') #4 /home/itgadget/public_html/system/packages/wbs/Wbs.php(189): User::getInfo('ADMINISTRATOR') #5 /home/itgadget/public_html/system/init.php(81): Wbs::loadCurrentUser() #6 /home/itgadget/public_html/published/index.php(3) in /home/itgadget/public_html/system/lib/model/DbModel.class.php on line 97

There was no problem during installation. What am I doing wrong?

Offline

 

#2 2011-04-11 13:24

wei
Member

Re: First Login Error for Shop-Script

I checked the Installer Diagnostics and saw some folders and several database tables missing. How can I fix this problem?

Offline

 

#3 2011-04-11 13:57

wei
Member

Re: First Login Error for Shop-Script

I created those missing folders so I got rid of those errors. But database?  How can I create them along with the correct number of fields?

Offline

 

#4 2011-04-11 21:14

wei
Member

Re: First Login Error for Shop-Script

I've solved the problem. First I login to the Installer as ADMINSTRATOR and delete both MySQL and Database link. Then I dropped all the partially created tables in the my database and rerun install.php.

Offline

 

Board footer

Powered by PunBB