Previous Thread
Next Thread
Print Thread
Hop To
#261877 12/11/2018 4:51 AM
Joined: Dec 2018
Posts: 32
A
Newbie
Newbie
A Offline
Joined: Dec 2018
Posts: 32
hi all,

I ran a backup of my ubb.threads 7.6.0 board via phpmyadmin and when I try to upload it to a test domain via the command line interface, I keep hitting the following error:

ERROR 1064 (42000) at line 468477: You have an error in your SQL syntax; check t he manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE HTML><html lang='en' dir='ltr'><head><meta charset="utf-8" / ><meta nam' at line 1

here's what line 468477 in the .sql file is:
SQL Query
<!DOCTYPE HTML><html lang='en' dir='ltr'><head><meta charset="utf-8" /><meta name="referrer" content="no-referrer" /><meta name="robots" content="noindex,nofollow" /><meta http-equiv="X-UA-Compatible" content="IE=Edge" /><style id="cfs-style">html{display: none;}</style><link rel="icon" href="favicon.ico" type="image/x-icon" /><link rel="shortcut icon" href="favicon.ico" type="image/x-icon" /><link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui.css" /><link rel="stylesheet" type="text/css" href="js/codemirror/lib/codemirror.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="js/codemirror/addon/hint/show-hint.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="js/codemirror/addon/lint/lint.css?v=4.7.7" /><link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?nocache=6111746217ltr&server=1" /><link rel="stylesheet" type="text/css" href="./themes/pmahomme/css/printview.css?v=4.7.7" media="print" id="printcss"/><title>somehost.com / localhost / database | phpMyAdmin</title><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=jquery/jquery.min.js&scripts%5B%5D=jquery/jquery-migrate-3.0.0.js&scripts%5B%5D=sprintf.js&scripts%5B%5D=ajax.js&scripts%5B%5D=keyhandler.js&scripts%5B%5D=jquery/jquery-ui.min.js&scripts%5B%5D=jquery/jquery.cookie.js&scripts%5B%5D=jquery/jquery.mousewheel.js&scripts%5B%5D=jquery/jquery.event.drag-2.2.js&scripts%5B%5D=jquery/jquery-ui-timepicker-addon.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=jquery/jquery.ba-hashchange-1.3.js&scripts%5B%5D=jquery/jquery.debounce-1.0.5.js&scripts%5B%5D=menu-resizer.js&scripts%5B%5D=cross_framing_protection.js&scripts%5B%5D=rte.js&scripts%5B%5D=tracekit/tracekit.js&scripts%5B%5D=error_report.js&scripts%5B%5D=config.js&scripts%5B%5D=doclinks.js&scripts%5B%5D=functions.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=navigation.js&scripts%5B%5D=indexes.js&scripts%5B%5D=common.js&scripts%5B%5D=page_settings.js&scripts%5B%5D=shortcuts_handler.js&scripts%5B%5D=codemirror/lib/codemirror.js&scripts%5B%5D=codemirror/mode/sql/sql.js&scripts%5B%5D=codemirror/addon/runmode/runmode.js&scripts%5B%5D=codemirror/addon/hint/show-hint.js&scripts%5B%5D=codemirror/addon/hint/sql-hint.js&v=4.7.7"></script><script data-cfasync="false" type="text/javascript" src="js/get_scripts.js.php?scripts%5B%5D=codemirror/addon/lint/lint.js&scripts%5B%5D=codemirror/addon/lint/sql-lint.js&scripts%5B%5D=console.js&v=4.7.7"></script><script data-cfasync='false' type='text/javascript' src='js/whitelist.php?v=4.7.7&token=496a11148f4b8316323c150711ad0ed5'></script><script data-cfasync='false' type='text/javascript' src='js/messages.php?l=en&v=4.7.7&token=496a11148f4b8316323c150711ad0ed5'></script><script data-cfasync='false' type='text/javascript' src='js/get_image.js.php?theme=pmahomme&v=4.7.7&token='></script><script data-cfasync="false" type="text/javascript">// <![CDATA[

possibly easier to read here: https://privatebin.net/?c043aac520cd2173#iEaPxaMDTXreQst1B+L02xBh3F7ONETe9oR165EZL9k=

I'm running mysql version 5.6 on my test server. any help is greatly appreciated!

Last edited by andrewjs18; 12/11/2018 4:55 AM.
Joined: Dec 2018
Posts: 32
A
Newbie
Newbie
A Offline
Joined: Dec 2018
Posts: 32
I'm wondering if there was a problem with the export from phpmyadmin...I might give it another try and see if the results are the same.

Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
If your database is no larger than 50mb or so you should not use phpmyadmin to create backups; as phpmyadmin is a web script it has to use PHP parameters including maximum execution time and other limits which will kill the transaction before it can complete.

You should instead create a backup via the command line interface (SSH) or another system tool (such as a backup utility in your hosting control panel).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Okay ,
I have never had s lot of issues with exporting via phpmyadmin except for sizes in the close to or exceed gb range.
But you may need to export again for a test.
But import yes

UBB only supports up to mysql 5.5+

requirements

PHP 5.4 - 5.6
MySQL 5.5+ or MariaDB

Meaning mysql 5.6 has not been tested.
You may need to downgrade your test server.

I assume you are using it on a local machine. We don't have enough info.
xamp,wamp or what.

You did create the database first correct? the file will only import to a existing database.
It will not create the database. Nor the user and password.
Plus when creating the database choose the same coalition.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Ruben
UBB only supports up to mysql 5.5+

requirements

PHP 5.4 - 5.6
MySQL 5.5+ or MariaDB

Meaning mysql 5.6 has not been tested.
You may need to downgrade your test server.

I believe your math is broken for today :/

UBB.threads works just fine with MySQL 5.5 or higher. the plus symbol ( + ) means 5.5 is the lowest version. Anything equal to or above 5.5 is recommended.

For example, many sites, including my own, are currently on MySQL 5.6 without issues.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2018
Posts: 32
A
Newbie
Newbie
A Offline
Joined: Dec 2018
Posts: 32
the issue was with phpmyadmin. when I did a mysqldump, I didn't have any issues uploading it!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
2 members (Geoff, domspeak), 353 guests, and 190 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)