Closed

SQL Error TYPE=MyISAM

Hi there,

My name is Imran Khan, I have interspire shopping cart software which is build on old php & mysql code and now a days hosting servers running lastest php & MySql versions. Now problem when i tried to install the shopping cart software on my online server and i got this error

" 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

'TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci' at line 13 "

A i searched and found that TYPE is obselete in New MySql Version so it has to be replaced with ENGINE.

Can you fix this error ? Moreover , will that be the only error i should expect due to changes in new MySql version or i should expect more errors.

can you get this fix ? how much time you need but i want no error arise later and php & MySql run smoothly.

regards,

Skills: HTML, Linux, MySQL, OSCommerce

See more: type myisam at line 11, table type myisam, type myisam auto_increment 1, type=myisam hibernate error, type myisam at line 5, you have an error in your sql syntax, myisam hibernate dialect, hibernate type=myisam, debug mode sql error 1114 table phpbb_sessions full, sql error 1064 order pdproducts_name line, 1064 sql error saving, image upload sql file type, sql error 256 1064, primavera sql error, phpbb mass email sql error, steel belted sql error, primavera installation sql error, creloaded sql error 1054, dotproject sql error, sql error fixing

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #17301775

13 freelancers are bidding on average £27 for this job

sudhanlogics

i there, Trust you are doing good!! I can understand your objective, you are in need of resolve SQL Error as I have team of SQL MySQL DBAs I would like to say I am confident enough that I can take care of your r More

£66 GBP in 1 day
(239 Reviews)
6.8
SaifuMak

I can replace mysql engine so that the error will never show :) there will be no errors because of engine change.

£18 GBP in 1 day
(246 Reviews)
6.5
hasanjack

Hi sir I am Hasan Jack and I can fix this error in your mysql I guarantee that you wont face this error again once it is fixed. Looking forward to hear from you. Best Regards, Hasan Jack

£20 GBP in 1 day
(30 Reviews)
5.8
YamenS

Hello, Can you fix this error ? Moreover , will that be the only error i should expect due to changes in new MySql version or i should expect more errors. Probably changing the database version will through more More

£111 GBP in 1 day
(59 Reviews)
5.6
retroshell

Hello Imran Khan, I've read your project details, I exactly know why the problem happened. I can fix it for you immediately, we need to take a backup from your database, create a new Database Schema suitable the new More

£18 GBP in 1 day
(21 Reviews)
4.9
£18 GBP in 1 day
(40 Reviews)
4.8
£23 GBP in 1 day
(6 Reviews)
4.6
coderrsl

Assalamualaikum Imran, I hope this message finds you well. from your post I can understand- your code followed php version which is less than PHP 5.0. but you didn't mention that [login to view URL] you are facing the p More

£19 GBP in 1 day
(11 Reviews)
3.4
ramanbaghla

"i can start your work right now" Hi there, i have gone through your complete project requirement and understood very well . i can resolve your mysql error on your server. as i have 6 year experience in website dev More

£20 GBP in 1 day
(12 Reviews)
3.6
£10 GBP in 1 day
(3 Reviews)
1.5
usamashaheen97

I am a newbie here on freelancer. But I have extensive web development experience. Furthermore I have been working on web development for 5 years now.I am quite comfortable working in this domain. I would also like More

£10 GBP in 1 day
(2 Reviews)
0.5
£10 GBP in 3 days
(0 Reviews)
0.0
£13 GBP in 2 days
(0 Reviews)
0.0