Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (mmkk, Gizmo, Ruben), 66 guests, and 278 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
M4TT
M4TT
Canada, SK
Posts: 48
Joined: March 2015
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
FREAK 11
M4TT 10
Ruben 5
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
SQL Corruption? #219458
11/20/08 08:52 AM
11/20/08 08:52 AM
Joined: Jun 2006
Posts: 9
J
Jason Carey Offline OP
stranger
Jason Carey  Offline OP
stranger
J
Joined: Jun 2006
Posts: 9
Hello all, I'm having a bit of a problem with my board and have tried to isolate it as much as I can. I believe down to a rogue SQL table. At this point it would be great to see if anyone else ever had this problem. Please visit the two different servers I have been testing with. The issue started on the live server and I have been trying to isolate on the test server.

Live Server: http://www.melaniesmusic.com/forums/ubbthreads.php
7.4b2 - php 4.027, mysql 4.1.22

Testing: http://208.131.128.192/forums/ubbthreads.php
7.4.1 - php 5.2.6, mysql 5.0.27

You can see that there are no images, and the whole page layout is scattered. It only happens in the user forums. The admin section is fine. This is the second time this has happened to me within a couple months. It was fixed the first time by my host restoring a backup. To set up the test server I exported from phpmyadmin with recommendations I found on this site from my live server and imported into a new database on the test server. I then installed a fresh 7.4.1 and did not restore any forums directory files (styles, templates, etc.) from the old (live) board. The only thing from the live board is the sql database.

So, I seemed to have isolated the issue down to a sql table somewhere, but I'm not sure which one would be responsible. I would rather not have to lose any information. Could it be a person posting malformed characters? Maybe it's a bug. Maybe my sql files became corrupted. I'm just not sure. I can supply sql backup files to the developers upon request.

There is also a separate issue, if I delete a second language folder, the users that had that language file selected can no longer log in to the board. Sometimes even after deleting cookies, etc. Any workarounds for that?

Thanks for any replies you can give me!

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."
Re: SQL Corruption? [Re: Jason Carey] #219463
11/20/08 10:07 AM
11/20/08 10:07 AM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,824
Lutz,FL
I see at least the paths are incorrect to your images.
Probably your templates have the wrong path also.
I would suggest you start over.
I would say you need to transfer your existing version to your test server first. Then follow the upgrade instructions.
I know at least the styles are saved in the database. So you may find it is more difficult to fix your sql tables than to start over.
Here is Gizmos transfer guide HERE

UBB Upgrade guide is HERE


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: SQL Corruption? [Re: Ruben] #219493
11/20/08 09:38 PM
11/20/08 09:38 PM
Joined: Jun 2006
Posts: 9
J
Jason Carey Offline OP
stranger
Jason Carey  Offline OP
stranger
J
Joined: Jun 2006
Posts: 9
Great resources, thank you. I may end up starting over, but wish I could pinpoint the source of the problem to satisfy the inner geek in me. Particularly because I didn't change anything to cause this. It appears to happen on its own. I don't log in for weeks at a time and every so often a user will email me and tell me its messed up again.

The test server is a new installation, except for the sql files, which to my knowledge shouldn't carry over anything that would mess up a layout that badly. So without my existing styles and templates, and it is still having the issue, that means its in a database somewhere. If one of the tables stores paths, shouldn't I be able to fix that from a control panel? And why is the admin section perfect but the public area messed up unless there are two different paths. And lastly, doesn't it seem likely that someone hacked something to cause this? I can't begin to imagine how this happens on its own. Thanks.

Re: SQL Corruption? [Re: Jason Carey] #219657
11/26/08 04:12 PM
11/26/08 04:12 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,824
Lutz,FL
It would be nice to know what you did to fix the problem!!!


Blue Man Group


There is no such thing as stupid questions. Just stupid answers

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,532
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)