PortalParts.com Site

 Forum Index > Geeklog > ChatterBlock Plugin Support New Topic Post Reply
 Chatterblock 3 install problem
 |  Printable Version
Anonymous: Anonymous
 November 12 2002 01:28 AM (Read 1296 times)  


Hi,

I tried upgrading Chatterblock and once I finished and got the install successful message, my site died and every page came up with the following error message :

1064: You have an error in your SQL syntax near '' at line 1

What went wrong? I rolled back and tried again with the same result..

Thanks


 
Quote
Blaine
 November 12 2002 07:23 AM  
Forum Admin
Admin

Status: offline

Registered: 03/01/02
Posts: 3576

I suspect your original block is still defined or you still have the phpblock code in lib-custom and it's trying to load it.

You may need to delete the block record using your SQL editor. If not - you may want to disable the plugin as well. To do that update the plugins record for Chatterblock Plugin - set enabled to 0.

When I've had this error during my testing of the upgrade it was due to these kind of issues.

Blaine


Please consider contributing to support my efforts ..
 
Profile Email Website PM
Quote
barrywong
 March 05 2003 01:45 AM  
Forum Big Cheese
Big Cheese

Status: offline

Registered: 02/16/03
Posts: 67

Dear Blaine

I made the following change to Chatterblock's User Function:
Enable Popup Alerts: No to Yes

and I got this error message:
1064: You have an error in your SQL syntax near ' newest_first=1 WHERE uid=4' at line 1 SQL in question: UPDATE ag_cb_userprefs SET history=86400,mode='static',static_lines=6, scroll_height=250, refresh_rate=300000,log_lines=20, popup_allowed=, newest_first=1 WHERE uid=4

Looking at your reply:
You may need to delete the block record using your SQL editor. If not - you may want to disable the plugin as well. To do that update the plugins record for Chatterblock Plugin - set enabled to 0.

How do I go about doing the following? ie.
1. which block record do I delete using my SQL editor?
2. Where do I go about changing the setting of Chatterblock Plugin to 0?

Thanks


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



 All times are CST. The time is now 11:29 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