Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (capnbob, JetStar, GregK), 39 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/08/06
Posts: 1465
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
SD 9
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#165366 - 10/09/06 06:53 AM error on importing from classic to threads
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
the script stops on:

The script stops on:

Importing moderator (Forum #27)
Script: E:\accounts\forum.domainame.com\root\www\ubbthreads\importers\classic_import.php
Line#: 1602
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO ubbt_MODERATOR_PERMISSIONS ( `USER_ID`, `MODERATOR_CAN_EDIT_USERS`, `MODERATOR_CAN_APPROVE_POSTS`, `MODERATOR_CAN_EDIT_POSTS`, `MODERATOR_CAN_LOCK_POSTS`, `MODERATOR_CAN_MOVE_POSTS`, `MODERATOR_CAN_DELETE_POSTS`, `MODERATOR_CAN_STICK_POSTS` ) VALUES ( '' ,0,1,1,1,1,1,1)

What to now??
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#165374 - 10/09/06 08:15 AM Re: error on importing from classic to threads [Re: webcare]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
I have delete all moderators in the old forum, and reinstall the script, but there where no errors this time, except the members where not imported also the admin, I have the members dir before the www root, is this the problem that it will not import?

There is no log file so I can see whats wrong, If the location of the members dir is the problem, how to solved it and wich files must I change?

John


Edited by webcare (10/09/06 08:16 AM)
Top
#165379 - 10/09/06 09:32 AM Re: error on importing from classic to threads [Re: webcare]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
It stuck because the members were not imported, and the importscript gives no error.... what is the normal location/path from the members dir in ubb classic? because I had tranfer it before the www root, and I do not remember the normal location?

Could someone tell me?


Edited by webcare (10/09/06 11:32 AM)
Top
#165407 - 10/09/06 11:38 AM Re: error on importing from classic to threads [Re: webcare]
Ron M Offline

Registered: 06/04/06
Posts: 361
Loc: Des Moines, IA
You should be able to get your Member's Directory path from your Paths & URLs section in your Classic Control Panel.

Moving this to Installation Help for now.
_________________________
Threads Alpha Tester
My Homepage
Top
#165414 - 10/09/06 11:44 AM Re: error on importing from classic to threads [Re: Ron M]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
I did copy the lines in the control panel into the importerfile but it seem not to import the members and the path is correct, because my old forum still works.
Top
#165440 - 10/09/06 12:14 PM Re: error on importing from classic to threads [Re: webcare]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
After getting the original error did you start over with the import or just try and resume where it left off?
Top
#165475 - 10/09/06 03:55 PM Re: error on importing from classic to threads [Re: Rick]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
I did a compleet new install, but evertime it fotgets to import the members, what to do now?
Top
#165476 - 10/09/06 04:08 PM Re: error on importing from classic to threads [Re: webcare]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Does it totally skip the members, or say it's importing them and just says it's done? If it tries to import them then it's possible it's not finding all of the members files. Check the path that your specifying for the Members Directory and make sure that all of your members files are in that directory.
Top
#165480 - 10/09/06 04:31 PM Re: error on importing from classic to threads [Re: Rick]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
Yes all the members are skiped and the import file is en and running normal.

I have only the members directory before the root file, make this a diference?

I did take the same path as in the controlpanel from the classic.

The old forum still works normal.
Top
#165482 - 10/09/06 04:39 PM Re: error on importing from classic to threads [Re: webcare]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It's tough to say what's going on for sure, the location *shouldn't* matter as long as PHP can read it. If you can, try this and let me know what you get back. Bring up classic_import.php?ubb=members

Let me know if it does anything or just says it's going to continue to the categories or shoutbox.
Top
#165484 - 10/09/06 04:54 PM Re: error on importing from classic to threads [Re: Rick]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
Below the error

Warning: sort() expects parameter 1 to be array, null given in E:\************\accounts\forum.*********.nl\root\www\ubbthreads\importers\classic_import.php on line 355

Done! About to import categories. (please wait)
(classic_import.php?ubb=importsomeconfigstuff#bottom)
Generated in 0.1069 seconds in which 0.031 seconds were spent on a total of 2 queries.
Top
#165486 - 10/09/06 05:01 PM Re: error on importing from classic to threads [Re: webcare]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, so that either means it's not able to find the members directory or there is some other issue.

The easiest thing would be if you can send me the ftp info to your server along with the URL to the import script so I can debug just a bit. You can either send it in a ticket or via a PT here.
Top
#165491 - 10/09/06 05:16 PM Re: error on importing from classic to threads [Re: Rick]
webcare Offline
newbie
Registered: 06/05/06
Posts: 38
This is the message:

I just collect the data and send it to you.


Edited by webcare (10/09/06 05:23 PM)
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image