Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Dunny), 46 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/09/11
Posts: 140
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#236275 - 04/18/10 09:23 AM mysql error after upgrade
KuKuKaChu Offline
member
Registered: 12/24/05
Posts: 122
Loc: Jakarta, Indonesia
i tried an upgrade from vs 7.4.1 to 7.5.5. it works ok, but sometimes the following error emerges:

Code:
Script: /var/www/vhosts/jakchat.com/httpdocs/forums/libs/mailer.inc.php
Line#: 60
SQL Error: 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 '' at line 3
SQL Error #: 1064
Query: SELECT STYLE_IMG, STYLE_VARS FROM ubbt_STYLES WHERE STYLE_ID = 


it happens in a few sections of the program, and is inconsistent in nature.
_________________________
JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#236276 - 04/18/10 09:40 AM Re: mysql error after upgrade [Re: KuKuKaChu]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
I'd check and make sure you don't have any empty styles, possibly even a forum assigned a specific style that might no longer exist?
Top
#236277 - 04/18/10 10:16 AM Re: mysql error after upgrade [Re: Rick]
KuKuKaChu Offline
member
Registered: 12/24/05
Posts: 122
Loc: Jakarta, Indonesia
it seems to be related to the styles and css.

i deleted all the unrequired styles till there was only one left. i then check all forums to ensure that they all used the default style.

now the situation is even worse: the style previews fine in the control panel, but the real page does not seem to load the css information, and page elements are scattered all over the place.
_________________________
JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users
Top
#236278 - 04/18/10 10:25 AM Re: mysql error after upgrade [Re: KuKuKaChu]
Dunny Online   coffee
addict
Registered: 01/16/08
Posts: 460
Loc: DE USA
I had a similar problem during an upgrade once. I had overwritten the file folder and decided to put them in manually later.... Had the same result that you are describing. I fixed it by going into the edit styles page, checking the style (that showed up correctly there) and just saved "changes" (I didn't actually make any). It resolved itself from there.

Dunny
_________________________
Dunny

Removed link due to bleedover spammers

Dawn of Iskirra
Top
#236280 - 04/18/10 08:34 PM Re: mysql error after upgrade [Re: Dunny]
KuKuKaChu Offline
member
Registered: 12/24/05
Posts: 122
Loc: Jakarta, Indonesia
thanks dunny (rather an australian-sounding nick there).

i had actually already tried that. but i decided just now to try again, and i noticed that there was no "default" chosen in the styles control panel. all the radio buttons were empty. so i chose one as default, saved, and that seems to have fixed the problem.
_________________________
JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image