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
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 :)
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.
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?
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?
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
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
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.
What other method did you use?
Thx!
Thx!
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.
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!
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