[Fixed] MariaDb Installation error

0tmy2

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

AlanJia2017

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?

0tmy2

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.

vot

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!

vot

Try to install revision #809

0tmy2

Install page does not load , blank , error 500

vot

#810

0tmy2

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.	File	Line	Code
1	admin.php	58	require(%s)
2	source/admincp/admincp_plugins.php	513	include_once(%s)
3	source/plugin/wechat/install.php	14	require_once(%s)
4	source/plugin/wechat/install/checkupdate.inc.php	110	runquery(%s)
5	source/function/function_plugin.php	246	discuz_database::query(%s)
6	source/class/discuz/discuz_database.php	137	db_driver_mysql->query(%s, false, false)
7	source/class/db/db_driver_mysql.php	153	db_driver_mysql->halt(%s, %d, %s)
8	source/class/db/db_driver_mysql.php	224	break()

vot

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...

0tmy2

Installation was successful , now need the fix for the forum db function which checks for mysql version.

Regards