Please select To the mobile version | Continue to access the desktop computer version
| |
| | |

CodersClub

 Forgot password?
 Register
Search
Author: 0tmy2
Collapse the left

[Fixed] MariaDb Installation error

[Copy link]

 India

 Author| Post time: 2018-05-22 23:11
| Show all posts
What the SQL query was wrong?


I dont know what you mean here.

But the error is the same in the new rev.

  1. run_sql_error
  2. SQL:CREATE TABLE pre_ucenter_applications ( appid int(11) unsigned NOT NULL auto_increment, `type` varchar(32) NOT NULL default '', `name` varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', authkey varchar(255) NOT NULL default '', ip varchar(15) NOT NULL default '', viewprourl varchar(255) NOT NULL, apifilename varchar( 255 ) NOT NULL DEFAULT 'uc.php', charset varchar(16) NOT NULL default '', dbcharset varchar(16) NOT NULL default '', synlogin tinyint(1) NOT NULL default '0', recvnote tinyint(1) DEFAULT '0', extra text NOT NULL, tagtemplates text NOT NULL, allowips text NOT NULL, PRIMARY KEY (appid)) TYPE=MYISAM
  3. Error:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 1
  4. Errno:1064
Copy the Code


Post time: 2018-05-23 05:04
| Show all posts
0tmy2 2018-5-22 13:58
Edited by 0tmy2 at 2018-5-22 13:59

There are some hacks posted regards to this on official discuz ...

Has the problem solved?

 India

 Author| Post time: 2018-05-23 10:19
| Show all posts
I am waiting on vot to update the fix he did , as it is not working , whereas using the hacks provided in the linked threads do work. But a repo update is the best way to go.

 Russia

Post time: 2018-05-23 19:43
| Show all posts
0tmy2: I dont know what you mean here.

I wanted to see a buggy SQL query, and you have posted that I wanted
  1. run_sql_error
  2. SQL:CREATE TABLE pre_ucenter_applications ( appid int(11) unsigned NOT NULL auto_increment, `type` varchar(32) NOT NULL default '', `name` varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', authkey varchar(255) NOT NULL default '', ip varchar(15) NOT NULL default '', viewprourl varchar(255) NOT NULL, apifilename varchar( 255 ) NOT NULL DEFAULT 'uc.php', charset varchar(16) NOT NULL default '', dbcharset varchar(16) NOT NULL default '', synlogin tinyint(1) NOT NULL default '0', recvnote tinyint(1) DEFAULT '0', extra text NOT NULL, tagtemplates text NOT NULL, allowips text NOT NULL, PRIMARY KEY (appid)) TYPE=MYISAM
  3. Error:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 1
  4. Errno:1064
Copy the Code

It is a good pointer to me where to fix a bug.
Thank you!

 Russia

Post time: 2018-05-23 21:11
| Show all posts
Try to install revision #809

 India

 Author| Post time: 2018-05-23 23:54
| Show all posts
Install page does not load , blank , error 500

 India

 Author| Post time: 2018-05-24 20:58
| Show all posts
Edited by 0tmy2 at 2018-5-24 21:01

Installation works.

But as I had mentioned earlier , there will be problems in other places.

When installing plugin

Discuz! Database Error(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 1CREATE TABLE IF NOT EXISTS common_member_wechat ( `uid` mediumint(8) unsigned NOT NULL, `openid` char(32) NOT NULL default '', `status` tinyint(1) NOT NULL DEFAULT 0, `isregister` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`uid`), UNIQUE KEY `openid` (`openid`)) TYPE=MYISAM



PHP Debug
No.FileLineCode
1admin.php58require(%s)
2source/admincp/admincp_plugins.php513include_once(%s)
3source/plugin/wechat/install.php14require_once(%s)
4source/plugin/wechat/install/checkupdate.inc.php110runquery(%s)
5source/function/function_plugin.php246discuz_database::query(%s)
6source/class/discuz/discuz_database.php137db_driver_mysql->query(%s, false, false)
7source/class/db/db_driver_mysql.php153db_driver_mysql->halt(%s, %d, %s)
8source/class/db/db_driver_mysql.php224break()



 Russia

Post time: 2018-05-24 21:22
| Show all posts
0tmy2: problems in other places

Yes of course.
I fixed the installation problems only.
If my idea is worked ok on the installation (you said it is ok),
I can continue to fix the same problems in other code...

 India

 Author| Post time: 2018-05-24 21:35
| Show all posts
Installation was successful , now need the fix for the forum db function which checks for mysql version.

Regards
You have to log in before you can reply Login | Register

Points Rules

Archive|Mobile|Dark room|CodersClub

Top.Mail.Ru
Top.Mail.Ru

2024-03-29 12:31 GMT+3 , Processed in 0.088984 sec., 7 queries .

Powered by Discuz! X3.4 Release 20230520

© 2001-2024 Discuz! Team.

MultiLingual version, Rev. 4301, © codersclub.org

Quick Reply To Top Return to the list