|
Joined: Nov 2001
Posts: 126
Junior Member
|
Junior Member
Joined: Nov 2001
Posts: 126 |
Control panel message Script: /raid/home/dancesafe/dancesafe/ubbthreads/admin/showuser.php Line#: 577 SQL Error: You have an error in your SQL syntax near ') AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter ' at line 4 SQL Error #: 2000 Query: SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter FROM w3t_Boards WHERE () AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter
Any ideas? I googled it and searched here, and nothing like what I have.
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
what are you clicking on when it does that? I remember reporting a similar bug last week, they are fixing in 6.5.2
|
|
|
|
Joined: Nov 2001
Posts: 126
Junior Member
|
Junior Member
Joined: Nov 2001
Posts: 126 |
It happens when I am either viewing someones profile and click edit, or finding a member from the control panel and trying to edit them in any way.
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
hmmm... have you modified profile files? Which version threads are you using?
|
|
|
|
Joined: Nov 2001
Posts: 126
Junior Member
|
Junior Member
Joined: Nov 2001
Posts: 126 |
6.5
And I dont believe I have.
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
ok, if no-one else has the answer, I'll be home shortly and look at it
|
|
|
|
Joined: Nov 2001
Posts: 126
Junior Member
|
Junior Member
Joined: Nov 2001
Posts: 126 |
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
this is the query I have there, check your code and see if it matches: <br />$query = "<br />SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter<br />FROM {$config['tbprefix']}Boards<br />WHERE $groupquery<br />AND Bo_Active='1'<br />ORDER BY Bo_Cat,Bo_Sorter<br />";<br />
|
|
|
|
Joined: Nov 2001
Posts: 126
Junior Member
|
Junior Member
Joined: Nov 2001
Posts: 126 |
Exactly the same
Here is a copy
$query = " SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter FROM {$config['tbprefix']}Boards WHERE $groupquery AND Bo_Active='1' ORDER BY Bo_Cat,Bo_Sorter ";
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
really odd - it's not causing me a problem. I see, it's an issue with your version, fixed in newer versions. find: <br />for ($i=0; $i<$gsize;$i++) {<br /> if (!preg_match("/[0-9]/",$Grouparray[$i])) { continue; };<br /> $g++;<br /> if ($g > 1) {<br /> $groupquery .= " OR ";<br /> }<br /> $groupquery .= "Bo_Read_Perm LIKE '%-$Grouparray[$i]-%'";<br />}<br /> add under: <br />if ($groupquery == "(") {<br /> $groupquery .= "1";<br />}<br />
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|