Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Fehler beim Installieren #8

Open
joachimdoerr opened this issue Mar 13, 2022 · 0 comments
Open

SQL Fehler beim Installieren #8

joachimdoerr opened this issue Mar 13, 2022 · 0 comments

Comments

@joachimdoerr
Copy link

joachimdoerr commented Mar 13, 2022

Das Problem scheint an den Dezimal Feldern z.b.

ADD order_total DECIMAL(,2) => sofern man im Query ADD order_total DECIMAL(10,2) notiert läuft das Query durch.

In der YForm-Manager install .json müsste man "precision":"" auf "precision":"10" ändern an 3 Stellen dann läuft die Installation durch.

AddOn warehouse konnte aus folgendem Grund nicht installiert werden:SQL error: Error while executing statement "ALTER TABLE rex_wh_orders ADD salutation varchar(191) DEFAULT '' NOT NULL , ADD firstname varchar(191) DEFAULT '' NOT NULL , ADD lastname varchar(191) DEFAULT '' NOT NULL , ADD birthdate varchar(191) DEFAULT '' NOT NULL , ADD company varchar(191) DEFAULT '' NOT NULL , ADD address varchar(191) DEFAULT '' NOT NULL , ADD zip varchar(191) DEFAULT '' NOT NULL , ADD city varchar(191) DEFAULT '' NOT NULL , ADD country text NOT NULL , ADD email varchar(191) DEFAULT '' NOT NULL , ADD createdate datetime NOT NULL , ADD paypal_id varchar(191) DEFAULT '' NOT NULL , ADD payment_id varchar(191) DEFAULT '' NOT NULL , ADD paypal_confirm_token text DEFAULT '' NOT NULL , ADD payment_confirm varchar(191) DEFAULT '' NOT NULL , ADD order_text text NOT NULL , ADD order_json text NOT NULL , ADD order_total DECIMAL(,2) , ADD ycom_userid text NOT NULL , ADD payment_type varchar(191) DEFAULT '' NOT NULL , ADD agecheck text NOT NULL , ADD session_id varchar(191) DEFAULT '' NOT NULL , ADD payed tinyint(1) NOT NULL , ADD imported tinyint(1) DEFAULT '0' NOT NULL ;": SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2) , ADD ycom_userid text NOT NULL , ADD payment_type varchar(1' at line 19

REDAXO
Version 5.13.2
PHP
Version 7.4.21
OPcache no
Xdebug no
Database
Version MySQL 5.7.34
Character set utf8mb4
Server
OS Darwin
SAPI cgi-fcgi
Webserver Apache/2.4.46
Packages
adminer 1.9.2
backup 2.8.0
be_style 3.0.1
be_style/redaxo 3.0.1
install 2.9.3
media_manager 2.12.1
mediapool 2.11.2
metainfo 2.8.4
phpmailer 2.11.1
project dev
structure 2.13.2
structure/content 2.13.2
url 2.0.1
users 2.8.2
ycom 4.0.6
ycom/auth 4.0.6
ycom/group 4.0.6
yform 4.0.2
yform/email 4.0.2
yform/manager 4.0.2
yrewrite 2.8.3
@joachimdoerr joachimdoerr changed the title SQL Fehler beim installieren SQL Fehler beim Installieren Mar 13, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant