Zen Cart Logo
Forums / Upgrading to 1.5.x / Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

Views: 3,735

Results 1 to 8 of 8
24 Aug 2023, 8:33 AM
#1
e_standard avatar

e_standard

New Zenner

Join Date:
Nov 2013
Location:
China
Posts:
75
Plugin Contributions:
0

Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

when updating zencart 1.57 to v1.58,the front page and admin page all how blank.would be appreciate if an expert could help,thanks.

--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' in /home/estand/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php:76
Stack trace:
#0 /home/estand/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(76): PDO->prepare('set names ''')
#1 /home/estand/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(PDO), Array)
#2 /home/estand/public_html/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()
#4 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(1064): call_user_func(Object(Closure))
#5 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#6 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#7 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect(true)
#8 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database{closure}('select * from ...', Array) #9 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure))
#10 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure)) #11 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select('select * from ...', Array, true)
#12 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#13 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#14 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#15 /home/estand/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get(Array)
#16 /home/estand/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels(Array)
#17 /home/estand/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#18 /home/estand/public_html/includes/application_top.php(204): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#19 /home/estand/public_html/index.php(25): require('/home/estand/pu...')
#20 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: '' (SQL: select * from plugin_control where (status = 1)) in /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure)) #1 /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure))
#2 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#4 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /home/estand/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/estand/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get(Array)
#7 /home/estand/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 /home/estand/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/estand/public_html/includes/application_top.php(204): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/estand/public_html/index.php(25): require('/home/estand/pu...')
#11 {main}
thrown in /home/estand/public_html/laravel/vendor/illuminate/database/Connection.php on line 712.

24 Aug 2023, 6:25 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

What sub-directories are present in the site's /zc_plugins directory?

My website

25 Aug 2023, 12:47 AM
#3
e_standard avatar

e_standard

New Zenner

Join Date:
Nov 2013
Location:
China
Posts:
75
Plugin Contributions:
0

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

lat9:

What sub-directories are present in the site's /zc_plugins directory?

Attachment 20361

It seems no other directories.

02.png
31 Aug 2024, 3:24 PM
#4
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

I got the exact same issue.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

31 Aug 2024, 3:37 PM
#5
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

but with 1.5.4 to 2.0 and mine states a character set

[31-Aug-2024 15:21:01 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' in /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php:75
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(75): PDO->prepare('set names 'iso-...')
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(PDO), Array)
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1181): call_user_func(Object(Closure))
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1217): Illuminate\Database\Connection->getPdo()
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->getReadPdo()
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->getPdoForSelect(true)
#8 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#9 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#10 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#11 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#12 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#13 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#14 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#15 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#16 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#17 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#18 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#19 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#20 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#21 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' (SQL: select * from `plugin_control` where (`status` = 1)) in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#11 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#12 {main}
  thrown in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php on line 760

[31-Aug-2024 15:21:01 UTC] Request URI: /zenmin/login.php?camefrom=index.php&zenAdminID=3cglaoqhi4b4te4197v8r8ara7, IP address: 40.77.167.38
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' in /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php:75
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(75): PDO->prepare('set names 'iso-...')
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(PDO), Array)
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1181): call_user_func(Object(Closure))
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1217): Illuminate\Database\Connection->getPdo()
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->getReadPdo()
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->getPdoForSelect(true)
#8 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#9 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#10 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#11 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#12 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#13 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#14 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#15 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#16 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#17 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#18 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#19 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#20 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#21 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' (SQL: select * from `plugin_control` where (`status` = 1)) in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#11 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#12 {main}
  thrown in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php on line 760.

[31-Aug-2024 15:21:01 UTC] Request URI: /zenmin/login.php?camefrom=index.php&zenAdminID=3cglaoqhi4b4te4197v8r8ara7, IP address: 40.77.167.38
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' in /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php:75
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(75): PDO->prepare('set names 'iso-...')
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(PDO), Array)
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#3 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1181): call_user_func(Object(Closure))
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(1217): Illuminate\Database\Connection->getPdo()
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->getReadPdo()
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->getPdoForSelect(true)
#8 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#9 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#10 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#11 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#12 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#13 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#14 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#15 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#16 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#17 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#18 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#19 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#20 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#21 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'iso-8859-1' (SQL: select * from `plugin_control` where (`status` = 1)) in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php(405): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2705): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/houseco/public_html/laravel/vendor/illuminate/database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get(Array)
#7 /home/houseco/public_html/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 /home/houseco/public_html/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/houseco/public_html/zenmin/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/houseco/public_html/zenmin/includes/application_top.php(20): require_once('/home/houseco/p...')
#11 /home/houseco/public_html/zenmin/login.php(8): require('/home/houseco/p...')
#12 {main}
  thrown in /home/houseco/public_html/laravel/vendor/illuminate/database/Connection.php on line 760.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

31 Aug 2024, 3:55 PM
#6
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

My best guesses are

  • Your storefront/admin configure.php files either don't contain a DB_CHARSET setting or that it doesn't reflect the actual character-set/collation of the database.
  • Your DB_CHARSET conflicts with the locale set in the site's storefront/admin main language file, e.g. lang.english.php
  • Your database has the dreaded "mixed collations", which can be corrected by the Database Conversion Tool: https://www.zen-cart.com/downloads.php?do=file&id=2367

My website

31 Aug 2024, 4:01 PM
#7
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

Quentin and I fixed the mixed collations. Now set to utf8mb4_unicode_ci
configure file define('DB_CHARSET', 'utf8mb4');

default language file
etlocale(LC_TIME, ['en_US', 'en_US.utf8', 'en', 'English_United States.1252']);

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

31 Aug 2024, 10:23 PM
#8
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Uncaught PDOException: SQLSTATE[42000] when updating zencart v1.57 to v1.58

Yeah, a "define('DB_CHARSET', 'iso-8859-1');" would do that. Should have been 'latin1'.

My website