phpMyBitTorrent Project Forums: Bug Reports for V2.X » Database SQL Error in Admin-Log Table Readout

Members

Help

Home

Home » Support Forums for PMBT 2.X » Bug Reports for V2.X » Database SQL Error in Admin-Log Table Readout

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Database SQL Error in Admin-Log Table Readout [message #2291]

Sat, 07 February 2009 23:14

Threedays

Messages: 79
Registered: January 2009
Location: Australia

Seeder

This error is happening in the Admin Log display's column 'Action'. Any idea?

Data base sql error

Error Executing SQL Query
Error ID: 1064
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND active = '1' AND warned = 'no'' at line 1

See me at ; http://conspiracyhub.com/

Report message to a moderator

Re: Database SQL Error in Admin-Log Table Readout [message #2295 is a reply to message #2291]

Sun, 08 February 2009 01:11

joeroberts

Messages: 1971
Registered: June 2006
Location: U.S.A

Releaser
Da HacKer

this is caused with search feald being blank.(some one clicking on search and not filling in the search feald)
I thought I had fixed that!
hmm let me look and see.

Your search page should look like this dose it?
http://phpmybittorrent.cvs.sourceforge.net/viewvc/phpmybitto rrent/pMBT/phpMyBitTorrent-hacks/html/search.php?revision=1. 5&view=markup

http://a.imageshack.us/img831/5562/mybikes.png

[Updated on: Sun, 08 February 2009 01:14]

Report message to a moderator

Re: Database SQL Error in Admin-Log Table Readout [message #2299 is a reply to message #2291]

Sun, 08 February 2009 03:30

Threedays

Messages: 79
Registered: January 2009
Location: Australia

Seeder

Ok I did tinker with the dead torrent part of search to remove the RSS icon. I've fix that code up not as I'd over commented.

It's now ;

if($dead == "ok") $rssdead = "&dead=ok";
else $rssdead = "";
//echo "<table align=\"right\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\"><tr><td>";
//RDF Button
//help(pic("rss.gif","backend.php?op=search&search=".urlencode(searchfield($search))."&cat=".$cat.$rssdead."&orderby=".$orderby."&ordertype=".$ordertype,null),_btcustomsearchexplain,_btcustomsearch);
//echo "<td class=\"smallish\">"._btsearchfeed."</td></tr></table>";
CloseTable();

The problem is really in the Adminstraitons Log Page. The column 'Actions' has this error.

See me at ; http://conspiracyhub.com/

Report message to a moderator

Re: Database SQL Error in Admin-Log Table Readout [message #2301 is a reply to message #2291]

Sun, 08 February 2009 04:41

Threedays

Messages: 79
Registered: January 2009
Location: Australia

Seeder

Joe just helped me out on this. Here are the changes needed.

update /include/functions.php

Goto line 246 in release 2.0.3 code.

$db->sql_query("UPDATE ".$db_prefix."_users SET seedbonus = seedbonus + '".$seedbonus."' WHERE id = $arr[userid] AND active = '1' AND warned = 'no'") or sqlerr(__FILE__, __LINE__);

should read ;

$db->sql_query("UPDATE ".$db_prefix."_users SET seedbonus = seedbonus + '".$seedbonus."' WHERE id = $arr[uid] AND active = '1' AND warned = '0'") or sqlerr(__FILE__, __LINE__);

So change 'userid' to 'uid'

See me at ; http://conspiracyhub.com/

[Updated on: Thu, 11 June 2009 13:22] by Moderator

Report message to a moderator

Previous Topic:	What is Mode Normal, Mode Expert in the ShoutBox?
Next Topic:	[PMBT2.0.X]Bug for torrent Prefix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Feb 08 21:33:45 GMT 2012

Total time taken to generate the page: 0.00694 seconds

.:: Contact :: Home ::.