Deploy errors. "You have an error in your SQL syntax."

Hey @eskalera,

If you creating the package with a different version of MySQL then the chances of having SQL conflicts gets higher the further the versions are apart.

In many cases the errors won’t effect your site. If you want to be 100% confident then you will need to locate the SQL insert that is failing. This means you will need to open the installer-data.sql file and locate one of the strings and find the insert statment. So in your case you find look for this string:

<meta property=”og:image” content=”https://trtms.com/wp-content/g&#8217;

Then find only its insert statement and then put it in a tool like phpmyadmin and see if it has any issues.

Most of these issues are related to data that wasn’t properly stored in the DB so when its injected into an insert statment it can cause issues.

If you want to try mysqldump it can sometimes fix these issues. To enable mysqldump go to the Settings menu link in the plugin.

Cheers~

First I tried to figure out what MySQL versions I was using. In the new site I have “5.5.35-cll” according to phpMyAdmin. But I didn’t know how to figure version in old site since I only have WordPress admin access.

So I located INSERT with errors and they all seemed to me to be pointing at the same INSERT: A very long one with html code and everything.

I tested that long INSERT as it was on phpMyAdmin and it succeeded.

I then found some other entries on my database that had not been created comparing to installer-data.sql queries. An uncountable amount. So I decided to just remove all database tables and execute the whole insert-data.sql through phpMyAdmin.

Finally everything seems to work and I even recovered my WordPress panel. The problem is everything links to old site again of course.

Finally I just replaced oldsite.com with newiste.com in the installer-data.sql before executing it in phpMyAdmin and it works like a charm now.

Thank you so much lifeinthegrid! If my approach is not correct or if it is vulnerable to any other known conflicts please let me know.

Sorry to everyone reading out there.

I just went back to the WordPress panel and is blank again. I am doubting now if I just saw it too quickly and it was really never fixed or maybe I saw some other admin panel. I don’t know but the truth is it’s gone again.

I followed same steps as before and phpMyAdmin did not throw any errors. All database entries are there but panels is still blank.

As a clue I’ve figured that if I inspect WordPress panel this is what I found: https://pastebin.com/D9k7X7ym

The relevant part says:

<b>Fatal error</b>: Access to undeclared static property: WP_Screen::$this in <b>/home/dkzonmmd/public_html/wp-admin/includes/screen.php</b> on line <b>706</b>

Any other suggestions please?

Hey @eskalera,

Did you happen to try the mysqldump option when generating the package?

Cheers~

Hi @lifeinthegrid,

I thought it would have the same effect as rebuilding the database from SQL command on phpMyAdmin, but I’ll definitely give it a shot and let you know the result.

Do I have to create a new package and installer?

Alleluia!

For anyone else with this issue. I have finally solved it with this solution

which summarizing says:

on line 706 of /wp-admin/includes/screen.php delete self:: on
<?php echo self::$this->_help_sidebar; ?>

A million thanks for your time @lifeinthegrid.

Excellent! Glad you got it going…