Error SQLSTATE[3D000] Ai

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
thushim
Posts: 7
Joined: 27 Jun 2019, 08:52

Error SQLSTATE[3D000] Ai

Post by thushim » 27 Jun 2019, 09:02

Hello,
Im new here.
I have installed the Aimoes web Shop distribution (Version 19.4.0) on Typo3 (9.5.7)(PHP Version 7.3.5)
When I click on the Aimeos Shop-Tab on the left side I get an error.
Typo 3 is installed on a local server (XAMPP)

Oops, an error occurred!
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

Can someone help how I can get the problem solved????

Thanks in advance

User avatar
aimeos
Administrator
Posts: 7873
Joined: 01 Jan 1970, 00:00

Re: Error SQLSTATE[3D000] Ai

Post by aimeos » 27 Jun 2019, 09:24

Strange error! Does it only occur when you are using the Aimeos admin interface?
Which software and versions are you using? MySQL, Apache, etc.?
Does the Aimeos update script in the Extension Manager yield errors if you execute it?
Can you reproduce it if you do a clean installation again?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

thushim
Posts: 7
Joined: 27 Jun 2019, 08:52

Re: Error SQLSTATE[3D000] Ai

Post by thushim » 01 Jul 2019, 11:26

It only occures when I try to use the Aimoes shop tab.
Apache 2.4.39 MySQL 5.0.12
if i execute the update script it says:
Configuration parameter "database" missing in "db"
I already made a new installation but error is still there

User avatar
aimeos
Administrator
Posts: 7873
Joined: 01 Jan 1970, 00:00

Re: Error SQLSTATE[3D000] Ai

Post by aimeos » 02 Jul 2019, 09:01

Are you sure you are using MySQL 5.0.12? This version is extremely old and unsupported.
The database name is used from your LocalConfiguration.php file, maybe the problem is there:
https://github.com/aimeos/aimeos-typo3/ ... rce.php#L9
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

thushim
Posts: 7
Joined: 27 Jun 2019, 08:52

Re: Error SQLSTATE[3D000] Ai

Post by thushim » 02 Jul 2019, 10:32

Sorry my fault ist version 10.1.40
I have solved the problem, with a new clean installation, but now i get another error

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'orderportal.mshop_locale_site' doesn't exist

User avatar
aimeos
Administrator
Posts: 7873
Joined: 01 Jan 1970, 00:00

Re: Error SQLSTATE[3D000] Ai

Post by aimeos » 02 Jul 2019, 10:49

Your tables haven't been created at all for some reason in that case. Please have a look at the end of the output of the update script to see what's the problem.

Version 10.1.40, is this MariaDB?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

thushim
Posts: 7
Joined: 27 Jun 2019, 08:52

Re: Error SQLSTATE[3D000] Ai

Post by thushim » 03 Jul 2019, 10:42

Problem solved
Changed charset to utf8 in the localconfig.php

Post Reply