bimmer
-
Posts
11 -
Joined
-
Last visited
Posts posted by bimmer
-
-
yeah, I fixed this but I still have a db error but can't figure out what's missing..
A database error occurredSQLSTATE[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 'PASSWORD('yoQhkgclUs')' at line 1
code:
$stmt = Database::prepare("
CREATE USER '" . $username . "'@'" . $access_host . "' IDENTIFIED BY 'password'
"); -
doesn't contain anything special but I checked your code if user and host is connected with a dot and it seems it doesn't work with mysql 8:
root@localhost [(none)]> CREATE USER 'somebody'.'localhost' IDENTIFIED BY 'PASSWORD';
ERROR 1064 (42000): 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 '.'localhost' IDENTIFIED BY 'PASSWORD'' at line 1
root@localhost [(none)]> CREATE USER 'somebody'@'localhost' IDENTIFIED BY 'PASSWORD';
Query OK, 0 rows affected (0.02 sec) -
1 hour ago, d00p said:
Is the file 1:1 the same as currently in git?
Now I tried to select all lines and inserted in a new file, named it as class.DbManagerMySQL.php and tried again.
The error is the same:
A database error occurredSQLSTATE[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 '.'127.0.0.1' IDENTIFIED BY 'password'' at line 1
Maybe there is a different way to create user in Mysql 8?
-
2 hours ago, d00p said:
I've committed the changes and the unit tests run perfectly fine. So, maybe a typo or similar from your side?
well I deleted these lines and inserted again, now I have a different error
A database error occurredSQLSTATE[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 '.`127.0.0.1` IDENTIFIED BY 'password'' at line 1
-
3 hours ago, d00p said:
The best try to manually enter the changes to the file
did it, this error occured:
Parse error: syntax error, unexpected '"host"' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /vhosts/ssl/lib/classes/database/manager/class.DbManagerMySQL.php on line 81
-
31 minutes ago, d00p said:
Are you on latest git-version?
sorry, forgot to mention, no git installed, production server
-
patch < db.patch
Hmm... Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|
--------------------------
File to patch: lib/classes/database/manager/class.DbManagerMySQL.php
Patching file lib/classes/database/manager/class.DbManagerMySQL.php using Plan A...
Hunk #1 failed at 66.
1 out of 1 hunks failed--saving rejects to lib/classes/database/manager/class.DbManagerMySQL.php.rej
done -
1 hour ago, d00p said:
Hm, okay, patch is on its way...if you do not use latest developer version (git) just remove every occurance of NO_AUTO_CREATE_USER in our code
thanks, removing it solved the problem. However with the old and the new version when I try to create a new database for a user this error occurs:
A database error occurredSQLSTATE[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 'IDENTIFIED BY 'password'' at line 2
-
1 hour ago, d00p said:
Output of the errors would be helpful.
here you are:
A database error occurredSQLSTATE[42000] [1231] Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
-
Hi All,
I just upgraded my server to mysql 8 with froxlor 0.9.38.7. It threw a couple mysql error during database creation so I decided to upgrade froxlor. However after the upgrade I can't even reach the login page due to a database error. Is it possible that froxlor latest is not compatible with mysql 8?? Or am I missing something?
Thanks a lot!
froxlor latest - mysql 8 support
in Development
Posted
cool, it works!
Thanks a lot mate!