Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 May 2008, 22:45
Internetcafe Internetcafe is offline
 
Join Date: May 2008
Database Error

I'm hoping to move to a VPS and the tech team at my new host have been attempting to restore my existing database but are continuously finding a database error created by :-


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I've checked all templates and removed a couple of places I found the '<br /> .. re-submitted the database for restore but the error continues to create a problem.

How can I run a query to locate the '<br /> within the database ?

Thanks guys
Reply With Quote
  #2  
Old 27 May 2008, 23:33
Farcaster Farcaster is offline
 
Join Date: Dec 2005
Real name: Robert Howard
You're probably going to find <br/> all over the place, actually. In the native format of templates and the cached page text from posts, etc, etc. If the import is failing though, they should be able to identify the particular insert statement that caused the failure though. I'm presuming this is coming from a mysqldump, of course, and not that it has been exported to a flat file. Once you have the exact error and the offending insert statement, that would give us enough information to help you identify what row in which table is causing the problem.
Reply With Quote
  #3  
Old 28 May 2008, 00:02
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Sounds like a character collation issue if they cant import the db because of the br tags.
Reply With Quote
  #4  
Old 28 May 2008, 00:47
Internetcafe Internetcafe is offline
 
Join Date: May 2008
Its not a <br /> problem .. notice the hyphen '<br />
Reply With Quote
  #5  
Old 28 May 2008, 03:21
Farcaster Farcaster is offline
 
Join Date: Dec 2005
Real name: Robert Howard
Originally Posted by Internetcafe View Post
Its not a <br /> problem .. notice the hyphen '<br />
Well, if there is an apostrphe in your data, it is most certainly escaped when being exported using the mysqldump. My previous statement stands. You need to find what row and what table this error is being caused on. They should be able to tell you that.
Reply With Quote
  #6  
Old 28 May 2008, 05:17
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
Originally Posted by Farcaster View Post
Well, if there is an apostrphe in your data, it is most certainly escaped when being exported using the mysqldump. My previous statement stands. You need to find what row and what table this error is being caused on. They should be able to tell you that.
If that was the case wouldn't almost all database dumps and restores fail as most have ' in them?
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #7  
Old 28 May 2008, 10:49
Internetcafe Internetcafe is offline
 
Join Date: May 2008
Tried again last night and techs report :-

ERROR 1064 (42000) at line 252033: 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 '<br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1
Grrrrrr
Reply With Quote
  #8  
Old 28 May 2008, 11:18
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
You need to increase your max execution time in php.ini

Also backingup/restoring databases via a web browser isn't recommended. You should use SSH when possible
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #9  
Old 28 May 2008, 12:12
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:23.

Layout Options | Width: Wide Color: