NukeCoder

Joined: Aug 29, 2009 Posts: 2

Getting table call errors through SQL... just wondering if this has to do with the fact that it is calling "electr28_" before the actual DB name. If so, do I need to use PHPmyadmin to fix it, and replace every one of these? Here's the code..

Code:

[08-29-09 10:33:28 am] [mdb2_error: message="MDB2 Error: no such table" code=-18 mode=callback callback=handle_pear_error prefix="" info="_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT username FROM nuke_users WHERE user_id = '2'] [Native code: 1146] [Native message: Table 'electr28_digitalshop.nuke_users' doesn't exist] "]
[08-29-09 10:33:28 am] [mdb2_error: message="MDB2 Error: no such table" code=-18 mode=callback callback=handle_pear_error prefix="" info="_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT p.*, u.username FROM shop_purchases p, nuke_users u WHERE p.user_id=u.user_id AND p.flags = '' ORDER BY p.timestamp DESC LIMIT 5] [Native code: 1146] [Native message: Table 'electr28_digitalshop.nuke_users' doesn't exist] "]
[08-29-09 10:33:28 am] [mdb2_error: message="MDB2 Error: no such table" code=-18 mode=callback callback=handle_pear_error prefix="" info="_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT p.*, u.username FROM shop_purchases p, nuke_users u WHERE p.user_id=u.user_id AND p.approved='0' AND p.flags <> '' ORDER BY p.timestamp DESC] [Native code: 1146] [Native message: Table 'electr28_digitalshop.nuke_users' doesn't exist] "]

[/code]

Posted: Sun Aug 30, 2009 10:05 am

Digital shop has to be in the same database as nuke. Reading your errors it looks like that isn't so OR your prefix is not nuke.