(Link to AcmlmWiki) Offline: thank ||bass
Register | Login
Views: 13,040,846
 Main | Memberlist | Active users | Calendar | Chat | Online users
Ranks | FAQ | ACS | Stats | Color Chart | Search | Photo album 		05-03-24 04:27 PM
0 users currently in Programming.
Acmlm's Board - I3 Archive - Programming - How to make acmlmboard work with mysql5 New poll | |
Add to favorites | Next newer thread | Next older thread
User Post
darkwitch

Red Cheep-cheep


 





Since: 10-16-06
From: Puerto Rico

Last post: 6283 days
Last view: 6283 days
Posted on 12-14-06 09:57 PM Link | Quote
I have tried everything but no result, I still don't have any idea where is the error. Just to explain, acmlmboard doesn't seems to work with MySQL5, or at least the threads. I'm sure soon all servers will have MySQL5 and some(maybe many) people wont be able to use it.

The error: No sql error, just the posts are not getting printed, the mod options are but not the posts.

Versions: 1.92.08/1.A2 maybe 1.92 too

And since I haven't used AB before, I have no idea whats the source of the problem.

Also, xkeeper seems to have fixed it here, but he wont spill the beans on how to fix it. D:

Any experienced programmer would like to share his thoughts? I attached thread.php/threadpost.php (1.92.08). no php file uploading D:, well that was smart...

For now I will add the " echo mysql_error(); " to see if it speaks.

(edited by darkwitch on 12-14-06 08:59 PM)
Randy53215

Melon Bug


 





Since: 11-17-05
From: Greenfield, Wisconsin (U.S.A)

Last post: 6284 days
Last view: 6283 days
Skype
Posted on 12-14-06 11:35 PM Link | Quote
Im not sure if it would be MySQL 5 or not, would you mind linking so I could check it out further? Also, any word on a mysql_error?
Cellar Dweller +

Red Koopa









Since: 11-18-05
From: Arkansas

Last post: 6293 days
Last view: 6284 days
Posted on 12-15-06 01:36 AM Link | Quote
Try searching thread.php for "FROM posts p,posts_text LEFT JOIN" and replace both occurrences with "FROM posts_text, posts p LEFT JOIN". ||bass talked about needing this fix in #rohmacking:
Originally posted by ||bass in IRC
Nov 26 23:33:56 ||bass the following query is wrong:
Nov 26 23:33:58 ||bass SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts p,posts_text LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:13 ||bass SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts_text, posts p LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:28 ||bass notice the very subtle difference
Nov 26 23:34:33 ||bass because
Nov 26 23:34:48 ||bass since you are using p in the ON clause
Nov 26 23:34:58 ||bass posts p has to be an immediate operand of the join
Nov 26 23:35:47 ||bass that is actual standardized sql syntax
Nov 26 23:36:03 ||bass i know mysql4 let you use any table from anywhere in the query in the join
Nov 26 23:36:12 ||bass for the on clause
Nov 26 23:36:21 ||bass but, at least if you read the standard
Nov 26 23:36:28 ||bass it's explicitly supposed to fail
Nov 26 23:36:31 ||bass which it does in php5
Nov 26 23:37:02 ||bass because the name resolution for an ON clause is only supposed to look as far as the immediate operands of the join keywords
Nov 26 23:37:40 ||bass i actually read the section of the standard in question last night when this came up and xkeeper asked me what was going on
Nov 26 23:38:40 ||bass the mysql 5 documentation cites it


If you are wondering why you can't attach PHP files, the reason is that, if allowed, someone could upload a PHP file and execute it on the server. There is only one PHP script in the attachment directory which was uploaded before Xkeeper added the file type restrictions. All it does is call phpinfo().
Add to favorites | Next newer thread | Next older thread
Acmlm's Board - I3 Archive - Programming - How to make acmlmboard work with mysql5 |


ABII

Acmlmboard 1.92.999, 9/17/2006
©2000-2006 Acmlm, Emuz, Blades, Xkeeper

Page rendered in 0.022 seconds; used 359.10 kB (max 427.34 kB)