PortalParts.com Site

 Forum Index > Geeklog > ChatterBlock Plugin Support New Topic Post Reply
 Chatterblock SQL Error
 |  Printable Version
rjrufo
 January 21 2004 08:46 AM  
Forum Full Poster
Full Poster

Status: offline

Registered: 01/18/04
Posts: 10

Maybe I'm overlooking something, but where is that code snippet from? I looked in cb_userprefs.php, and a few others, but couldn't seem to find it anywhere. I was getting tired last night and decided to start again this morning, but before I do, I figured that I'd ask which file it is in.


 
Profile Email PM
Quote
Blaine
 January 21 2004 09:58 AM  
Forum Admin
Admin

Status: offline

Registered: 03/01/02
Posts: 3576

cb_userprefs.php - line 137


Please consider contributing to support my efforts ..
 
Profile Email Website PM
Quote
rjrufo
 January 21 2004 11:15 AM  
Forum Full Poster
Full Poster

Status: offline

Registered: 01/18/04
Posts: 10

Ok, well, I looked into the code a little bit, and it appears that MySQL likes capitol letters for query functions. I changed your code snippit to:
if ( $HTTP_POST_VARS['xcb_popup'] == 1) {;
$query = DB_query("SELECT max(id) FROM {$_TABLES['cb_chatterlog']}");
list($cb_userconfig['popup_allowed']) = DB_fetchARRAY($query);
} else {
$cb_userconfig['popup_allowed'] = 0;
}

I don't have the error message now, but it still seems that I have to go through and correct the rest of the code so that MySQL 4.0.17 knows what I'm asking of it, as it doesn't seem to produce the results I wanted. I don't have the time to go through everything right now, but I'll tackle it within the next week or so.

Thank you Blaine for all your help. If you'd like, I can e-mail you the corrected code when I have it completed and tested to make sure I get the correct results. That way, you'll know that it works for the latest version of MySQL.


 
Profile Email PM
Quote
Content generated in: 0.26 seconds
New Topic Post Reply



 All times are CST. The time is now 11:33 PM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Anonymous users can post 
Filtered HTML Allowed 
Censored Content