Moving my pp classified to another site

horsetrailertalk · May 15th, 2006, 09:33 AM

why is it that everthing is great but from step 2-3 when it writes the database tables...it all errors and the error is:

Step 3: MySQL error reported: [CREATE TABLE pp_favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL default '0', product int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (product)) TYPE=MyISAM]
Result: Table 'pp_favorites' already exists

This shows for all tables???

Chuck S · May 15th, 2006, 10:02 AM

That would show because your running install.php again and the tables exist. They are duplicate errors and should be there so no worries just rerun through install

horsetrailertalk · May 15th, 2006, 10:07 AM

I just ran it once and it went to this error. It doesn't take me to the next step or ask about the vb integration...

horsetrailertalk · May 15th, 2006, 10:10 AM

when you finish the install and it prompts to go to the control panel...

the Edit links take you to mydomain.com

Chuck S · May 15th, 2006, 10:15 AM

Okay well your PHP install seems to not be reporting the domain correctly. On install there are update queries to update the urls to the ones you input so somewhere this would be failing

You can use phpmyadmin to edit the entries in the Photopost settings table directly in the database or if you tell me the domain I can give you some update query commands.

horsetrailertalk · May 15th, 2006, 10:39 AM

www.turbodub.com

that is where this is going

Chuck S · May 15th, 2006, 10:54 AM

These might help you need to change the prefix to your classifieds prefix just run these in phpmyadmin or if your database is with vbulletins run these in the sql box of vb admin

Code:

Content visible to verified customers only.

horsetrailertalk · May 15th, 2006, 11:04 AM

now I get...

Warning: chdir(): No such file or directory (errno 2) in /home/content/n/e/i/neilsgli/html/classifieds/header-inc.php on line 60

Warning: main(./global.php): failed to open stream: No such file or directory in /home/content/n/e/i/neilsgli/html/classifieds/header-inc.php on line 61

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/local/lib/php') in /home/content/n/e/i/neilsgli/html/classifieds/header-inc.php on line 61

From www.turbodub.com/classifieds

Chuck S · May 15th, 2006, 11:32 AM

That would be because on the last step of install your path to the forums was not correct. you can edit your config-intc.php file and input the proper path to your forum in the $vbpath variable.

horsetrailertalk · May 15th, 2006, 01:29 PM

OK...that seems fixed now. But it is not keeping my log in as admin. I also noticed on the main admin sonfig section...the option of vb integration isn't showing. How can I fix this?

horsetrailertalk · May 15th, 2006, 01:30 PM

It isn't reconizing me as the admin and giving me access to click the admin when logged in.

Chuck S · May 15th, 2006, 02:13 PM

Did you verify in the database the setting 41 is the proper integration? Are your cookies aligned to the new domain name?

horsetrailertalk · May 15th, 2006, 02:39 PM

I changed the line 41 to vb3

Now I get this error on the site

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/forums/vb3.php on line 296

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /classifieds/forums/vb3.php on line 25

I have been working on this all day. It is not an easy task....

Chuck S · May 15th, 2006, 02:40 PM

Make sure your config file has the proper database settings then on setting 83 of the database tables make sure you enter the proper table prefix for vb

horsetrailertalk · May 15th, 2006, 03:05 PM

OK...that worked...seeming one last thing...

My vb login is the administrator...but in the classified section it doesn't see me as the admin. The admin link is not displaying.

Where could that setting be?

horsetrailertalk · May 15th, 2006, 03:20 PM

Says I have no admin privlages

horsetrailertalk · May 15th, 2006, 03:24 PM

When I try to log in here: http://www.turbodub.com/classifieds/adm-index.php it logs me in ok but...

it takes me to the classifeds page....not the control panel

horsetrailertalk · May 15th, 2006, 03:43 PM

it doesn't display the member list inside the classified section either. So it appears that it is not authenticating so to speak with my vbulletin. I have checked and the prefixes and all are correct.

It shows me logged in etc.

Chuck S · May 15th, 2006, 03:47 PM

Set your cookie prefix in the settings table setting 182 I beleive to bb and try again

horsetrailertalk · May 15th, 2006, 03:49 PM

It is and was set to bb

Anything else I can try?