SQL backup from Elxis backend

[Ivan Trebješanin]

Hi,
I didn't want to bother anyone, but this is what I get everytime I try to import SQL dump I made from admin panel. First two times I was thinking that I'm doing something wrong, but this is the third time, so I want to know if someone have imported SQL dump and how? Below is the text I get from phpmyadmin.


SQL query:

INSERT INTO elx_components( id, name, link, menuid, parent, admin_menu_link, admin_menu_alt,
OPTION , ordering, admin_menu_img, iscore, params )
VALUES (
"1", "Banners", "", "0", "0", "", "Banner Management", "com_banners", "0", "js/ThemeOffice/component.png", "0", ""
);

MySQL said: Documentation
#1064 - 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 'option,ordering,admin_menu_img,iscore,params) VALUES ("1","Banners","","0","0","' at line 1

[datahell]

We have discussed this issue in the past.
You must surround the word "option" in backticks (`). "option" is a reserved word in mysql and that's why creates problems parsing the sql file. So, you must edit the sql file and do the replacements before trying to import it.

Example:

INSERT INTO elx_components( id, name, link, menuid, parent, admin_menu_link, admin_menu_alt,
`option`, ordering, admin_menu_img, iscore, params )

You can also add backticks to all other column names if you wish.


To fix this issue in Elxis 2006.4 do the following
Open /administrator/components/com_database/drivers/mysql.php

Go to line 139.
Replace this:

$temp_sql.=' ('.@implode(',',$fields).')';

with this:

$temp_sql.=' (`'.@implode('`,`',$fields).'`)';

Save the file. Done!

Create a new backup file. That file can be imported without errors.

This fix has already been applied to Elxis 2007

[Ivan Trebješanin]

Thank you, so much datahell,

I'm really embarrassed to bother you, You've helped me a few times already, and I know you're so busy right now. I hope I will be able to return this favour sometime.

[datahell]

No one forces me to reply. I reply because I want to help people that honoured us by using Elxis. Don't hesitate to ask and please don't say that you bother me.