Results 1 to 8 of 8
  1. 24 Aug 2023, 09:33 AM #1
    e-standard
    e-standard is offline New Zenner
    Join Date
    Nov 2013
    Location
    China
    Posts
    75
    Plugin Contributions
    0

    Default 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.
    Reply With Quote Reply With Quote
  2. 24 Aug 2023, 07:25 PM #2
    lat9's Avatar
    lat9
    lat9 is offline Administrator
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,742
    Plugin Contributions
    95

    Default 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
    Reply With Quote Reply With Quote
  3. 25 Aug 2023, 01:47 AM #3
    e-standard
    e-standard is offline New Zenner
    Join Date
    Nov 2013
    Location
    China
    Posts
    75
    Plugin Contributions
    0

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

    Quote Originally Posted by lat9 View Post
    What sub-directories are present in the site's /zc_plugins directory?
    Name: 02.png Views: 181 Size: 13.5 KB

    It seems no other directories.
    Reply With Quote Reply With Quote
  4. 31 Aug 2024, 04:24 PM #4
    delia's Avatar
    delia
    delia is offline Totally Zenned
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,365
    Plugin Contributions
    23

    Default 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
    Reply With Quote Reply With Quote
  5. 31 Aug 2024, 04:37 PM #5
    delia's Avatar
    delia
    delia is offline Totally Zenned
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,365
    Plugin Contributions
    23

    Default 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
    Code:
    [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
    Reply With Quote Reply With Quote
  6. 31 Aug 2024, 04:55 PM #6
    lat9's Avatar
    lat9
    lat9 is offline Administrator
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,742
    Plugin Contributions
    95

    Default 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
    Reply With Quote Reply With Quote
  7. 31 Aug 2024, 05:01 PM #7
    delia's Avatar
    delia
    delia is offline Totally Zenned
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,365
    Plugin Contributions
    23

    Default 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
    Reply With Quote Reply With Quote
  8. 31 Aug 2024, 11:23 PM #8
    lat9's Avatar
    lat9
    lat9 is offline Administrator
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,742
    Plugin Contributions
    95

    Default 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
    Reply With Quote Reply With Quote
 

 
« Previous Thread | Next Thread »

Similar Threads

  1. v154 Uncaught SyntaxError and Uncaught TypeError: $(...).cycle is not a function
    By targetmarts in forum General Questions
    Replies: 4
    Last Post: 8 Mar 2018, 07:48 AM
  2. New zencart version updating automatically?
    By lilrowo in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 22 Aug 2010, 04:55 AM
  3. SQLSTATE[42S02]: Base table or view not found -- when using oscommerce module
    By pattinsonrobert in forum General Questions
    Replies: 0
    Last Post: 19 Sep 2009, 07:11 AM
  4. Zencart Errorpage even when not anywhere in Zencart?
    By renaissanceart in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 19 Feb 2009, 10:04 AM
  5. Updating Zencart Versions
    By tmanlick in forum General Questions
    Replies: 1
    Last Post: 25 Dec 2007, 04:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

disjunctive-egg
Content and Graphics Copyright (c) 2003 - 2025 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC