News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

problems to convert vb 3.6.8 to smf 1.1.3

Started by c42mx, September 12, 2007, 01:22:04 PM

Previous topic - Next topic

c42mx

when wanting to run the convert.php gives me the following error

[color=red]Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.6. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'c42mx_smf1'@'localhost' for table 'user'[/color]


somebody could helpme

GrayFox

#1
I'm curious about this. I'm about to make this same conversion, so I'll need to know what to do if I run into this problem. Hopefully it won't happen to me, though.

EDIT: I am having the same problem.  :'(

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.6. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.



The error MySQL gave was: SELECT command denied to user 'gforums_smf'@'localhost' for table 'user'

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Kirby


directhostinguk

I'm trying to convert vB 3.6.8 to smf 1.1.4 but get this error:

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Unsuccessful!
This query:
ALTER TABLE `directhost_smf`.smileys
ORDER BY LENGTH(code) DESC;
Caused the 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 'LENGTH(code) DESC' at line 2

Kirby

Please create a separate topic next time ;)
The converter developer, JayBachatero, could best answer this.

SleePy

Open the .sql file and find
LENGTH(code)

Replace
code

Kirby and other interested,
From what I know this is due to a mysql bug not allowing to do a ORDER BY with a the LENGTH mysql function.
Simply have to remove the LENGTH function and it should work.
MySQL development team has to fix this, so until then its just a manual fix.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Kirby


JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: