Just reloaded the new db, the same error occured.
Need some logins Ben?
I was under the impression that the site is on a local environment. Yes, if you could grant us temporay admin access to the site I can check. You can do so via private reply.
Is this dev site where you developed the site? Or was it developed locally, migrated to the dev site then migrate it to the live site?
I just did an export of the development site’s DB and was able to import it without problems on my local dev server. Check the screenshot for the settings. Were you using the same?
We developed the site on a VPS with a subdomain .
The user (in DirectAdmin) was already created with the right URL (tsvisuals.nl).
So when the site went live. We claimed the domain, gave in the right DNS settings, adjusted the database and removed the subdomain.
Is this a clear story?
Thanks for the explanation. Back to my question though, were you using the same settings as above when you exported the DB from the dev site? I can assure you now that there is indeed a problem on your DB. I just downloaded the DB of the live site and checked into the postmeta table and compared it with the one I have and here’s just a strip of what I found.
This is from the DB I just exported from the dev site using the settings above.
s:141:"<h2 style="text-align: center;"><a href="http://www.tsvisuals.nl/producten/fotopanelen/photo-panel-aluminium/">Photo panel Aluminium</a></h2>";
s:141 means that the string after it contains 141 characters which is true.
This is from the DB of the live site
s:146:"<h2 style=“text-align: center;”><a href=“http://www.tsvisuals.nl/producten/fotopanelen/photo-panel-aluminium/”>Photo panel Aluminium</a></h2>";
As you can see, they are basically the same except this time, the first line is s:146 which is wrong since the string only contains 141 characters and that’s where the problem occurs.
Try exporting the DB again using the same settings as above, wipe the DB of the live site clean then import it again.
Hope this makes sense.
I did everything just as you said and showed, but the error stays the same.
Need phpmyadmin access for the live site?
I just did and it imported with no problems. Check the live site and see if it’s fine?
Ben, your my hero of today!
I don’t know how it happend or where it went wrong in my process, but thanks, thanks, many thanks.
Will send a tweet about this great support!
No problem! Glad we got it figured out. Have fun using The Beaver!