Previous Thread
Next Thread
Print Thread
Hop To
#236275 04/18/2010 9:23 AM
Joined: Dec 2005
Posts: 122
member
member
Joined: Dec 2005
Posts: 122
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
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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?

Joined: Dec 2005
Posts: 122
member
member
Joined: Dec 2005
Posts: 122
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
Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
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

Joined: Dec 2005
Posts: 122
member
member
Joined: Dec 2005
Posts: 122
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
0 members (), 686 guests, and 131 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)