Hey everyone,

I am trying to import the MXDIR_cats file into mySQL for mxdirectory, so I don't have to manually create my directory catagories.

I log into myPhpAdmin and go to the "xoops_xdir_cats" table, and select "browse" under the Or Location of the textfile option and select the file.

I get the following error:

"#1146 - Table 'branthq.XSM_xdir_cat' doesn't exist"

So, I tried going to the "Insert data from a textfile into table" option, select the file again and I get the following error:

"#1045 - Access denied for user: 'branthq@localhost' (Using password: YES)"

So, I go into the MXDIR_cats file and change XSM_xdir_cat to xoops_xdir_cat and try again, thinking this might work...

Then I get this errror:

"#1064 - You have an error in your SQL syntax near '154, 0, 'Art and Collectibles', 'http://')' at line 1 "

brantHQ is the name of my site, if your wondering why that is thrown in there. I have a table called "xoops_xdir_cat", but nothing that says XSM_xdir_cat.

Can anyone advise me on what I am doing wrong? I am sure it's something very stupid. I have tried from MyPhpAdmin on my server through Plesk, and then tried with the MyPhpAdmin module installed in Xoops.

Thank you in advance.