english 
Thread Options  Search this Thread  
Post: #1
12-11-2017 12:20 PM
katil2008


Joined: 04-11-2017
Posts: 6
Country: Turkey
Male katil2008 is Offline now
MySql error
Hello,

I created a topic here once about internal server error, I tried at another hosting service and problem solved. well, I created an MySql, entered the informations at install page. and I got an error,

Processing file: torrent.sql
Starting at the line: 1
Error at the line 17: ) TYPE=MyISAM;
Query: CREATE TABLE `addedrequests` ( `id` int(10) unsigned NOT NULL auto_increment, `requestid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`id`), KEY `userid` (`userid`), KEY `requestid_userid` (`requestid`,`userid`) ) TYPE=MyISAM;
MySQL: 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 9
Stopped on error

anyone had a idea how can I solve it?

Post: #2
12-11-2017 23:53 PM
alanb
TS Support Team


Joined: 15-11-2006
Posts: 3,118
Country: United States of America
Awards:  
Male alanb is Offline now
MySql error
TYPE keyword is depreciated (since 5.0) and not supported in MySQL5.5

If you have root server access you need to edit your my.ini file and set

default-storage-engine=MYISAM

remember to restart mysql server after editing my.ini
The following user says thank you to alanb for this useful post:

Post: #3
13-11-2017 08:39 AM
katil2008


Joined: 04-11-2017
Posts: 6
Country: Turkey
Male katil2008 is Offline now
MySql error
Hello, Thank you for your interest. I have ftp access to the server only. And where is my.ini file? this question can be rediculous for ya maybe, but I do not have experience much. Greetings.

Post: #4
14-11-2017 05:49 AM
alanb
TS Support Team


Joined: 15-11-2006
Posts: 3,118
Country: United States of America
Awards:  
Male alanb is Offline now
MySql error
Originally Posted by katil2008
Hello, Thank you for your interest. I have ftp access to the server only. And where is my.ini file? this question can be rediculous for ya maybe, but I do not have experience much. Greetings.
That will not help you any. You will need a host with root access. ( Such as a VPS or dedicated server )

Post: #5
22-11-2017 22:08 PM
katil2008


Joined: 04-11-2017
Posts: 6
Country: Turkey
Male katil2008 is Offline now
MySql error
Hello, I got it. Do we have a free version that can I use with greater than 5.2 MySql, I need to use with my school, and cannot pay unfortunately. Awaiting your helps. Thank you

Quick Reply
Decrease Size
Increase Size
Insert bold text Insert italic text Insert underlined text Align text to the left Align text to the centerr Align text to the right Justify text Insert quoted text Code Insert formatted PHP code Insert formatted SQL code
Colors
Insert hyperlink Insert image Insert email address
Smilies
Insert hidden text



Forum Jump: