SQL Table Reading Error [asdf]


Views: 20,052,551	Home \| Forums \| Uploader \| Wiki \| Object databases \| IRC Rules/FAQ \| Memberlist \| Calendar \| Stats \| Online users \| Last posts \| Search	04-25-24 05:40 AM
Guest:

0 users reading SQL Table Reading Error [asdf] | 1 bot

Main - Computers and technology - SQL Table Reading Error [asdf]

Hide post layouts | New reply

shibboleet

Posted on 07-29-13 02:17 AM

Link | #29227

Fire Mario
DROP TABLE users;

Level: 123

Posts: 1790/4661
EXP: 20890088
Next: 341178

Since: 07-07-12

Last post: 1349 days ago
Last view: 361 days ago

So, everybody should know my Newer Luigi board I'm hosting for another guy.

Well, before I moved the board to another domain, the uploader worked fine.

But when I moved it, it doesn't read the SQL table I have assigned to it.

Here's the error:

/NewLuigiTeam/lib/mysql.php:141   backTrace()
/NewLuigiTeam/lib/mysql.php:108   rawQuery('...')
/NewLuigiTeam/get.php:11   query('...', 3)


Table 'newerluigi_New.uploader' doesn't exist

Query was: select * from uploader where id = '3'MySQL Error.

Well what's odd is, it's reading the wrong table. I uploaded a file, and it showed up on NSLBWuploader table in PHPMA.

Because I set the table prefix like this in config/database.php:

$dbserv = 'localhost';
$dbuser = 'newerluigi_New';
$dbpass = 'Hell No, you ain't getting this.';
$dbname = 'newerluigi_New';
$dbpref = 'NSLBW';

So it reads the prefix fine, but reads the wrong table.

Any help?

____________________
a

Arisotura

Posted on 07-30-13 12:13 AM

Link | #29286

Star Mario
in this room you have a pile of apple pies

Level: 163

Posts: 1646/9019
EXP: 56258671
Next: 228973

Since: 07-03-12
From: in a box

Last post: 13 days ago
Last view: 22 hours ago

Search for

select * from uploader where id =

and replace it with

select * from {uploader} where id =

Should work. Or alternately, don't use a database prefix.

____________________
NSMBHD - Kafuka - Jul
melonDS the most fruity DS emulator there is

zafkflzdasd

shibboleet

Posted on 07-30-13 12:20 AM

Link | #29287

Fire Mario
DROP TABLE users;

Level: 123

Posts: 1798/4661
EXP: 20890088
Next: 341178

Since: 07-07-12

Last post: 1349 days ago
Last view: 361 days ago

It already exists in the file
Line 139:

$entry = Fetch(Query("select * from {uploader} where id = {0}", $fid));

____________________
a

Main - Computers and technology - SQL Table Reading Error [asdf]

Hide post layouts | New reply

Page rendered in 0.017 seconds. (2048KB of memory used)
MySQL - queries: 28, rows: 198/198, time: 0.009 seconds.
[powered by Acmlm]