View Full Version : Moving my pp classified to another site
May 15th, 2006, 10: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???
May 15th, 2006, 11: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
May 15th, 2006, 11: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...
May 15th, 2006, 11:10 AM
when you finish the install and it prompts to go to the control panel...
the Edit links take you to mydomain.com
May 15th, 2006, 11: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.
May 15th, 2006, 11:39 AM
that is where this is going
May 15th, 2006, 11: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
UPDATE cp_settings SET setting='http://www.turbodub.com/classifieds/data' WHERE id=6;
UPDATE cp_settings SET setting='http://www.turbodub.com/classifieds' WHERE id=11;
UPDATE cp_settings SET setting='http://www.turbodub.com/classifieds/images' WHERE id=49;
UPDATE cp_settings SET setting='http://www.turbodub.com/classifieds/uploads' WHERE id=82;
May 15th, 2006, 12:04 PM
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
May 15th, 2006, 12:32 PM
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.
May 15th, 2006, 02: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?
May 15th, 2006, 02:30 PM
It isn't reconizing me as the admin and giving me access to click the admin when logged in.
May 15th, 2006, 03:13 PM
Did you verify in the database the setting 41 is the proper integration? Are your cookies aligned to the new domain name?
May 15th, 2006, 03: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....
May 15th, 2006, 03: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
May 15th, 2006, 04: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?
May 15th, 2006, 04:20 PM
Says I have no admin privlages
May 15th, 2006, 04: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
May 15th, 2006, 04: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.
May 15th, 2006, 04:47 PM
Set your cookie prefix in the settings table setting 182 I beleive to bb and try again
May 15th, 2006, 04:49 PM
It is and was set to bb
Anything else I can try?
May 15th, 2006, 04:54 PM
I also deleted cookies on my pc and refreshed that way too...
still no luck.
May 15th, 2006, 05:24 PM
thanks for leaving me hanging. I have only been working on this from 9 this morning it is now 5:30
May 15th, 2006, 06:37 PM
Please be patient when posting a response and let someone have time get back to you.
If you are logging into admin and the login loops the cookie prefix is always the culprit
Usually recheck the prefix against your config.php file of vb to make sure it is bb and then make sure the license number in your vb config also matches what you have in your classifieds config-inc.php file.
May 16th, 2006, 08:43 AM
Chuck...sorry just frustrated as hell. OK...the prefix is bb in both. I did have a different license number...which i changed and still nothing.
The only other thing i can think of is when I was changing the chmod...on one folder i applied to all subfiles...
Would this have something to do with it?
May 16th, 2006, 09:13 AM
No the license number and cookie prefix are what would trigger this
I registered a name and was logged in when viewing the classifieds although I had no permissions which means you dont have them set or your usergroups table in classifieds is empty.
Did you move the database from the old server?
May 16th, 2006, 09:14 AM
no was a fresh install - didn't move it
May 16th, 2006, 09:28 AM
i am looking in the database...it shows 1 Admisitrator. I am trying to figure out how to see what the user name is...
May 16th, 2006, 09:33 AM
OK Chuck...I figured out what it is...the usergroup id's in the classified install don't match the usergroup ids in the forum
May 16th, 2006, 09:34 AM
Your usergroups table in Photopost should have many entries under it but it must have at least one your admin insert. Your Administrator entry in there must have a groupid of 6 and then cpaccess set to 1
You can try setting the username I registered as admin and let me see what I get trying to get to admin
May 16th, 2006, 09:34 AM
why are they not talking? when it wrote the tables...It made the admin usergroup 6 when actually the admin usergroup in the forum is 5
May 16th, 2006, 09:39 AM
that fixed it...but I manaully changed the user group id inside the data base.
why did it not match up during the install? How do i correct this so I don't have to manually change these?
May 16th, 2006, 09:56 AM
You possible initially installed with the wrong integration it would appear.
May 16th, 2006, 10:00 AM
OK...so once I manually fix these user groupids in the database...should it be ok from here on out?
Or do I need to do something in order for it to communicate properly?
May 16th, 2006, 10:03 AM
do I need to re install a particular file or anything?
May 16th, 2006, 10:12 AM
Yeah Chuck...I just created a new user group in my forum...it did not write to the pp_usergroups in the classified database??
How do i fix this?
May 16th, 2006, 10:19 AM
You need to resync the usergroups in the photopost side to grab your vb usergroups especially when creating a new one
May 17th, 2006, 03:40 PM
OK Chuck...thanks for the help...everything is good now ....
The Navbar links in the classifieds links to www.turbodub.com/classifieds/timeslips.php & the same for the vbgarage link.
The links should be www.turbodub.com/timeslips.php etc.
How can I edit this...the links are correct inside the forum.
May 17th, 2006, 05:10 PM
You would fix those links in your navbar or whereever you have them in the specific vb template to be full urls and not relative urls and this should do it.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.