Thread: database error
View Single Post
  #1  
Old 10th July 2008, 20:50
Fynnon's Avatar
Fynnon Fynnon is offline
xxx
 
Join Date: Nov 2007
P2P
Posts: 984
Default database error
[hr:38lyhf5s]
Hi again, i`m sorry but i got another error while testing your source today:

On the left side menu (Personal) when i go to Bookmarks it gives me this error:

Code:
General Error
SQL ERROR [ mysql4 ]

Unknown column 't.moderated' in 'field list' [1054]

SQL

SELECT b.id AS bookmarkid, u.name AS username, u.uid AS owner, u.privacy, t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.filename, t.owner, t.hidden, t.numratings, t.ratingsum, t.save_as, t.numfiles, t.filename, t.size, t.completed, t.category, t.hidden, t.moderated FROM bookmarks b, torrents t, users u WHERE b.userid = 1 AND b.torrentid = t.fid AND t.owner = u.uid ORDER BY t.ctime DESC LIMIT 0,30

BACKTRACE

FILE: include/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: bookmarks.php
LINE: 100
CALL: dbal_mysql->sql_query()
you can test this on my demo: www.bvlist.com/nafed
Reply With Quote