Post: #1
|
||
katil2008 Joined: 04-11-2017 Posts: 6 Country: |
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
|
|||
alanb TS Support Team Joined: 15-11-2006 Posts: 3,118 Country: Awards: |
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 |
||
|
|||
|
Post: #3
|
|
katil2008 Joined: 04-11-2017 Posts: 6 Country: |
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
|
|
alanb TS Support Team Joined: 15-11-2006 Posts: 3,118 Country: Awards: |
MySql error Originally Posted by katil2008 That will not help you any. You will need a host with root access. ( Such as a VPS or dedicated server )
|
|
|
Post: #5
|
|
katil2008 Joined: 04-11-2017 Posts: 6 Country: |
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
|
|
|
«
Previous Thread
|
Next Thread
»
|