Advertisement:

Author Topic: vbulletin 3.6.x to smf 1.1.2 error  (Read 3847 times)

Offline emre_

  • Semi-Newbie
  • *
  • Posts: 22
vbulletin 3.6.x to smf 1.1.2 error
« on: March 08, 2007, 06:59:15 AM »
Converting members... Unsuccessful!
This query:
SELECT
u.userid AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.password, 1, 64) AS passwd,
SUBSTRING(u.email, 1, 255) AS emailAddress,
SUBSTRING(u.homepage, 1, 255) AS websiteTitle,
SUBSTRING(u.homepage, 1, 255) AS websiteUrl,
SUBSTRING(u.icq, 1, 255) AS ICQ, SUBSTRING(u.aim, 1, 16) AS AIM,
SUBSTRING(u.yahoo, 1, 32) AS YIM, SUBSTRING(u.msn, 1, 255) AS MSN,
SUBSTRING(IF(u.customtitle, u.usertitle, ''), 1, 255) AS usertitle,
u.lastvisit AS lastLogin, u.joindate AS dateRegistered, u.posts,
u.reputation AS karmaGood, u.birthday_search AS birthdate,
SUBSTRING(u.ipaddress, 1, 255) AS memberIP,
SUBSTRING(u.ipaddress, 1, 255) AS memberIP2,
CASE
WHEN u.usergroupid = 6 THEN 1
WHEN u.usergroupid = 5 THEN 2
WHEN u.usergroupid = 7 THEN 2
ELSE 0
END AS ID_GROUP,
CASE WHEN u.usergroupid IN (3, 4) THEN 0 ELSE 1 END AS is_activated,
SUBSTRING(u.salt, 1, 5) AS passwordSalt,
SUBSTRING(ut.signature, 1, 65534) AS signature, '' AS lngfile,
'' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS avatar, '' AS secretQuestion,
'' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
'' AS smileySet
FROM `gvbulletin`.user AS u
LEFT JOIN `gvbulletin`.usertextfield AS ut ON (ut.userid = u.userid)
WHERE u.userid != 0
LIMIT 0, 500;
Caused the error:

SELECT command denied to user 'gopcasmf'@'localhost' for table 'user'

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: vbulletin 3.6.x to smf 1.1.2 error
« Reply #1 on: March 08, 2007, 11:28:37 PM »
Search is your friend. Common conversion errors.
Follow me on Twitter

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