Forums

Could not convert database value "O:69:\"Concrete\\Cor..." to Doctrine Type object

Permalink 1 user found helpful
Ok, i ran into this problem before and thought is was related to duplicating a site, however I built a site from scratch on a local MAMP server, but when I move it to the Live server I get an error with anything related to files:

Could not convert database value "O:69:\"Concrete\\Cor..." to Doctrine Type object

`FileStorageLocations` (`fslID`, `fslName`, `fslConfiguration`, `fslIsDefault`) VALUES
(1, 'Default', 'O:69:\"Concrete\\Core\\File\\StorageLocation\\Configuration\\DefaultConfiguration\":1:{s:10:\"\\0*\\0default\";b:1;}', 1);

I see the error if I try to view any site page (I can still see most of the dashboard pages), the file manager or the file storage locations page.

When moving, I had cleared and turned off all caches and pretty urls was off, all I had to do was change the application/config/database.php setting for it to reconnect, a process I have done dozens of times with other sites without issue.

Please help, all help greatly appreciated :)

# concrete5 Version
Core Version - 5.7.5.13
Version Installed - 5.7.5.13
Database Version - 20160615000000
# concrete5 Packages
Cookies Disclosure (0.9.4), ExchangeCore reCAPTCHA (1.1.1), Page Redirect (2.0), Page Selector Attribute (2.0)
# Server Software
Apache
# Server API
apache2handler
# PHP Version
5.4.40
# PHP Extensions
apache2handler, apc, bcmath, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, pspell, Reflection, session, SimpleXML, soap, sockets, SourceGuardian, SPL, sqlite3, standard, tidy, timezonedb, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib
# PHP Settings
Viewing 15 lines of 35 lines. View entire code block.
BHWW
 
BHWW replied on at Permalink Reply
BHWW
Please can anyone help, I have tried so many things and can't make any sense of this. It happens whenever I try and migrate a site from my local MAMP instance to my server, or back into the MAMP instance. It can be a completely new install and i get the issue.

Its like the File Storage Location becomes disconnected, but I can't work out why?

Please can someone help, i've going spare!

http://update.energique.fitness...

Thanks
BHWW replied on at Permalink Reply
BHWW
Ok, so i’ve got it working!

I’d call it a hack and hopefully it will be fixed in the future, but nobody else seems to have the same issue so one can but hope.

In the meantime, if i install a new instance of concrete5, then delete all the database tables except the File Storage Locations, and delete all the files - upload my local files and the database without the File Storage Locations table, it all seems to work!

--

If it helps to understand the issue, in a bunch of the data of the imported site, I am seeing

\r\n
\r\n

New line statements I think, however i can go through and delete them, but maybe that was something to do with the FSL table issue?
hshoghi replied on at Permalink Reply
Hi
I do think that the issue is with the files
Has a better solution come along.
It should not be so hard to make a copy of the site for migration.

Thank you

Hesam
BHWW replied on at Permalink Reply
BHWW
I have since found the issue was with the export of db from MAMP using phpMyAdmin, so found another way to export the db and seemed to work.
hshoghi replied on at Permalink Reply
What other method did you use?

Thx!
BHWW replied on at Permalink Reply
BHWW
Sure, sorry wasn't at computer when I wrote the answer... I installed MySQLWorkbench from MAMP and exported from there, the db was fine then.
mpunkt82 replied on at Permalink Reply
Yeah! This did it for me!!! Thanks a lot! Hours of try and error. I thought I hang myself! Thanks from germany! Have a nice weekend!