[wp-testers] Null comment problem

Mon Jan 28 06:23:09 GMT 2008

If it all fails...

do it all MANUALLY... means from yr old host, get an SQL Dump (with DROP IF 
EXIST, CREATE IF NOT EXIST ) and then manually insert the old ones to the 
new structure.

Nothing of which , I noted there are 2 tables which are not there in old 
tables (REF to FANTASTICO INSTALLS) which are POST2CAT and LINK2CAT (all 
lower case) which I explained here http://www.azrin.net/?p=668 and it's a 
common fault when U move from one host to another.

Forcing upgrades don't do much if the old tables are not there....

Best regards

Dr Azrin  ( www.azrin.net )
Operator for KEDAI -dot- Everything www.kedai.tv
iExploreAsia Medical Group UK
part of the BBS.NU Community Websites.
a member of BBS.NU-Info Perkahwinan-EbayTrust Alliance

Promoting Better Family Values for all
Registered in the UK Under EU Reg No: GB823680232; Lansing,Michigan USA ; 
Singapore and Malaysia (652297W)
Licensed Network Operators in the US and Singapore *(9VB-428D)

Data Protection Act: All memorandums and Electronic Communications may be 
subjected to Non-Disclosure Agreements. If you are not the intended 
receipent, please destroy this email and notify the admin.Contents are 
subjected to OFFICIAL SECRETS ACT, FREEDOM OF INFORMATION and  PATRIOT ACTS.
Some of the content are of the person's personal comments and bear no 
bearing on the Company. Standard Disclaimers Apply.
----- Original Message ----- 
From: "Zhao Qianli" <zhao.qianli at gmail.com>
To: <wp-testers at lists.automattic.com>
Sent: Sunday, January 27, 2008 8:11 PM
Subject: Re: [wp-testers] Null comment problem

> OK, DD32, I will try your advice and take a look what will happen.
>
> 2008/1/27, DD32 <wordpress at dd32.id.au>:
>>
>> As lloyd posted, You might want to try forcing a database upgrade, I dont
>> think you have done that yet.
>>
>> http://codex.wordpress.org/FAQ_Installation#How_do_you_force_a_database_upgrade.3F
>>
>> (Note: You can also edit the option via the admin panel if you can login,
>> http://site/url/wp-admin/options.php)
>>
>>
>> On Sun, 27 Jan 2008 21:02:04 +1100, George Pearce <george at gpearce.co.uk>
>> wrote:
>>
>> > Try posting in the forum, I was under the impression that this was for
>> the
>> > beta and bleeding versions of Wordpress? Please ignore me if I'm wrong,
>> > that's just what I thought it was.
>> > Maybe trying using fresh files with the same database would help?
>> >
>> >
>> > Regards;
>> > -George
>> > George at GPearce.co.uk
>> > -----Original Message-----
>> > From: wp-testers-bounces at lists.automattic.com
>> > [mailto:wp-testers-bounces at lists.automattic.com] On Behalf Of Zhao
>> Qianli
>> > Sent: 27 January 2008 02:56
>> > To: wp-testers at lists.automattic.com
>> > Subject: Re: [wp-testers] Null comment problem
>> >
>> > OK, I run Wordpress 2.3.2. This problem occurred after I changed
>> hosting, I
>> > can give you my whole operations:
>> >
>> > 1. backup wordpress database on Dreamhost 2. build a null new database
>> on
>> > new hosting 3. import database backup to the new database 4. transfer
>> old
>> > wordpress folder (include all wordpress files and plugins and themes)
>> from
>> > Dreamhost to new hosting via SSH 5. alter wp-config.php to match new
>> > database 6. re-direct domain  to new hosting  IP 7. successful access 
>> > to
>> new
>> > site
>> >
>> > I think these steps are ok, but I met that problem :(, maybe a fresh
>> > installation is better?
>> >
>> > 2008/1/27, azrin <azrin at bbs.nu>:
>> >>
>> >> Dreamhost is known to do that...
>> >> run an upgrade before you put it live.
>> >>
>> >>
>> >> ----- Original Message -----
>> >> From: "Lloyd Budd" <lloydomattic at gmail.com>
>> >> To: <wp-testers at lists.automattic.com>
>> >> Sent: Saturday, January 26, 2008 11:45 PM
>> >> Subject: Re: [wp-testers] Null comment problem
>> >>
>> >>
>> >> > Hello Zhao,
>> >> >
>> >> > You haven't said what version of WordPress you are running? Are you
>> >> > able to duplicate the problem on in your test clean LAMP 
>> >> > environment?
>> >> >
>> >> > Cheers,
>> >> > Lloyd
>> >> >
>> >> > On Jan 26, 2008 4:00 AM, Zhao Qianli <zhao.qianli at gmail.com> wrote:
>> >> >> Hi, I met a curious problem after I transfered my blog from
>> >> >> Dreamhost
>> >> to
>> >> >> another hosting. I  directly applied old database instead of new
>> >> >> installation, but now I have received  notified email from my blog
>> >> >> constantly like this (there are 42 emails so far):
>> >> >>
>> >> >>
>> >> >> A new comment on the post # "" is waiting for your approval
>> >> >>
>> >> >>
>> >> >> Author :  (IP:  , )
>> >> >> E-mail :
>> >> >> URL    :
>> >> >> Whois  : http://ws.arin.net/cgi-bin/whois.pl?queryinput=
>> >> >> Comment:
>> >> >>
>> >> >>
>> >> >> Approve it: http://techpush.com/wp-admin/comment.php?action=mac&c=0
>> >> >> Delete it: http://techpush.com/wp-admin/comment.php?action=cdc&c=0
>> >> >> Spam it:
>> >> http://techpush.com/wp-admin/comment.php?action=cdc&dt=spam&c=0
>> >> >> Currently  comments are waiting for approval. Please visit the
>> >> moderation
>> >> >> panel:
>> >> >> http://techpush.com/wp-admin/moderation.php
>> >> >>
>> >> >> You see, all fields are null, but I can't see these moderating
>> >> >> comments in wordpress admin panel and I really don't know where
>> >> >> they come from.
>> >> >> --
>> >> >> Zhao Qianli
>> >> >> http://thinkinglog.info
>> >> >> http://techpush.com
>> >> >> _______________________________________________
>> >> >> wp-testers mailing list
>> >> >> wp-testers at lists.automattic.com
>> >> >> http://lists.automattic.com/mailman/listinfo/wp-testers
>> >> >>
>> >> >
>> >> >
>> >> >
>> >> > --
>> >> > Lloyd Budd | Digital Entomologist | | Skype:foolswisdom
>> >> > WordPress.com | WordPress.org | Automattic.com
>> >> > _______________________________________________
>> >> > wp-testers mailing list
>> >> > wp-testers at lists.automattic.com
>> >> > http://lists.automattic.com/mailman/listinfo/wp-testers
>> >>
>> >> _______________________________________________
>> >> wp-testers mailing list
>> >> wp-testers at lists.automattic.com
>> >> http://lists.automattic.com/mailman/listinfo/wp-testers
>> >>
>> >
>> >
>> >
>> > --
>> > Zhao Qianli
>> >
>> > http://thinkinglog.info
>> > http://techpush.com
>> >
>> > _______________________________________________
>> > wp-testers mailing list
>> > wp-testers at lists.automattic.com
>> > http://lists.automattic.com/mailman/listinfo/wp-testers
>> >
>>
>>
>>
>> _______________________________________________
>> wp-testers mailing list
>> wp-testers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-testers
>>
>
>
>
> -- 
> Zhao Qianli
>
> http://thinkinglog.info
> http://techpush.com
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers 