Go Back   Pligg CMS Forum > Pligg Help > General Help

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-02-2007, 01:00 PM
Casual Pligger
 
Join Date: May 2006
Posts: 93
Thanks: 3
Thanked 7 Times in 6 Posts
Warning when moving Pligg from one host to another

I moved Pligg Beta 9.0 from DreamHost to another host.

The site seems to be working fine except for the following which appears at the top:

Quote:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/showbloc/public_html/vote/libs/dbtree.php on line 322
URL: http://www.showblocked.info/vote/

PHPinfo: http://www.showblocked.info/phpinfo.php

Any help is highly appreciated?
Reply With Quote
  #2 (permalink)  
Old 06-02-2007, 01:03 PM
AshDigg's Avatar
Mayor of PliggVille
 
Join Date: Dec 2005
Posts: 1,623
Thanks: 237
Thanked 346 Times in 207 Posts
See if this helps.
__________________
- Ash
Reply With Quote
The Following User Says Thank You to AshDigg For This Useful Post:
  #3 (permalink)  
Old 06-02-2007, 09:13 PM
Casual Pligger
 
Join Date: May 2006
Posts: 93
Thanks: 3
Thanked 7 Times in 6 Posts
It worked. I did the change via phpMyAdmin.

The SQL query for the same is:

Code:
UPDATE `pligg_categories` SET `category__auto_id` = '0' WHERE `pligg_categories`.`category__auto_id` =5 LIMIT 1 ;
In the above code, replace 'pligg_categories' with the name of categories table as appropriate. Usually it will be just 'categories' or 'pligg_categories'.

Last edited by srikat; 06-29-2007 at 01:27 PM.
Reply With Quote
Reply

Thread Tools
Display Modes
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
Permissioning required for backup to work? Swakoo General Help 2 08-11-2008 11:31 PM
cann't vote in pligg (buliding 802) haxhax Bug Report 27 03-10-2007 05:53 AM
ERROR: my_base_url is not set. Please correct this using the admin panel. Then refres search Installation and Upgrade Help 7 11-14-2006 09:35 PM
Page titles & breadcrumbs AshDigg Core Development 11 06-30-2006 06:35 PM


Search Engine Friendly URLs by vBSEO 3.2.0