PDA

View Full Version : conversion errors


randycarroll
09-12-2003, 03:05 AM
https://vborg.vbsupport.ru/showthread.php?t=56479&highlight=database+error+importing

I get that same error, mine exactly is:
Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: SELECT g_id AS importusergroupid,g_view_board AS canview,g_mem_info AS canviewmembers,
g_other_topics AS canviewothers,g_use_search AS cansearch,g_email_friend AS canemail,
g_edit_profile AS canmodifyprofile,g_post_new_topics AS canpostnew,
g_reply_own_topics AS canreplyown,g_reply_other_topics AS canreplyothers,
g_edit_posts AS caneditpost,g_delete_own_posts AS candeleteownpost,
g_open_close_posts AS canopenclose,g_delete_own_topics AS candeletethread,
g_post_polls AS canpostpoll,g_vote_polls AS canvote,g_use_pm AS canusepm,
g_is_supmod AS ismoderator,g_access_cp AS cancontrolpanel,g_title AS title,
g_max_mass_pm AS maxbuddypm
FROM chh_forums.ibf_groups
ORDER BY importusergroupid
LIMIT 0,4
mysql error: select command denied to user: 'chh_vb@localhost' for table 'ibf_groups'

mysql error number: 1142

Date: Thursday 11th of September 2003 11:03:02 PM
Script: http://www.chinohillshigh.net/forums//forums//importers/bbimport_invib.php
Referer: http://www.chinohillshigh.net/forums//importers/bbimport_invib.php


when I am runnign the import script for Invision to VBulletin. Please help, ill give some webspace or soemthign to whoeer fixes this first.

Dean C
09-12-2003, 06:47 AM
If you have an unhacked vbulletin/invison board and you are using the importer available from vbulletin.com then I suggest you submit a support ticket :)

randyc
09-12-2003, 12:34 PM
what if it is hackeD?

pie
09-12-2003, 05:41 PM
denied...... have you been given the right privalleges on mysql???

randyc
09-12-2003, 08:02 PM
i got the most permission i know of...
I really dont want to bother the admin for more of em..hehehh
I treat it like an object.
Should I be able to convert a hacked Invision to ubb or soemthing then convert that to VB?

randyc
09-13-2003, 04:53 AM
I just had an epiphany...
heres my idea,

Can I take my current forums members, posts and topics and permissions and export them in the SQL Toolbox, then import them to a new fresh unmodded version of Inivision (with a seperate DB) and then import that fresh DB? I dont mind losing PMs and stuff, its just the members and the topics need to stay.

any help appreciated, ill reward iwth either five dollars via paypal or a month of hosting.

randyc
09-13-2003, 04:01 PM
bump