Seo Panel patch files for 3.3.0 - hot fixes released

[seopanel_forum]

We are releasing patch files for hot fixes in Seo Panel version 3.3.0

It will fix following issues

1) Keyword rank position issue in google search results

Please do following steps to apply patches to fix above issues

1) Download patch file from following location => http://www.seopanel.in/patch/seopanel_patch_330.sql

2) Import it to your seo panel database using PHPmyadmin or any mysql client. Please check the following video tutorial for importing sql file to mysql database using phpmyadmin.

http://www.youtube.com/watch?v=fywMpgFzpKk

or

Execute following sql query in your seo panel database using PHPmyadmin or any mysql client.

Code: Select all

UPDATE `searchengines` SET
`regex` = '<li.*?class="?g.*?<a.*?href="\\/url\\?q=(.*?)&amp;sa=U.*?>(.*?)<\\/a>.*?<\\/div><span.*?>(.*?)<\\/span>'
WHERE `url` LIKE '%google%';

or

Upgrade to latest version 3.3.1

Simply use Softaculous / Installatron / Webuzo / AMPPS to install and upgrade SEO Panel or Please download latest version from http://www.seopanel.in/download/

Installation Steps => http://www.seopanel.in/install/
Upgrade Steps => http://www.seopanel.in/install/upgrade/

Enjoy seo panel features

[Karel]

Visited the forum to report the google keyword issue, but you guys are fast!! :D
Thanks.

Patched the mysql and right now I'm generating keyword reports. I'll give you feedback about the results.
Meanwhile I was studying the changed files.

I think this need to be added to the mysql patch:
[code]DROP TABLE IF EXISTS `themes`;[/code]

[url=http://code.google.com/p/seopanel/source/diff?spec=svn317&old=305&r=317&format=unidiff&path=%2Ftrunk%2Fseopanel%2Finstall%2Fdata%2Fupgrade.sql]seopanel/install/data/upgrade.sql[/url]

Grr, no BBCode.

[Karel]

No edit button. :(

Here is the promised feedback.
Ran Seo Tools Generate Keyword Reports for all sites and only for the google searchengine.

Never saw "Keyword not assigned to required search engines........" message before, but then again I always rely on my cronjob. The cronjob runs only once during the night.

I've got about 875 keywords to crawl, only 25% was successfully crawled.

If I remember correctly, generating keyword reports and executing the cron, multiple times skips the successfully crawled keywords. So I may be forced to do just that. In previous versions this wasn't necessary.

[francoeme]

Hello.

I upgrade to Seo Panel 3.3.0 and the reports are not generated.

I newly upgrade to 3.3.1 and reports remain missing.

My cron job is set ok.

When I run Report Generation Manager manually, the message "The database tables could not be found" appears.

Can you help me?

[seopanel_forum]

Hello.

I upgrade to Seo Panel 3.3.0 and the reports are not generated.

I newly upgrade to 3.3.1 and reports remain missing.

My cron job is set ok.

When I run Report Generation Manager manually, the message "The database tables could not be found" appears.

Can you help me?

Please do following steps

http://forum.seopanel.in/viewtopic.php?f=6&t=3871

Its an issue with mysql connection.

[seopanel_forum]

Visited the forum to report the google keyword issue, but you guys are fast!!
Thanks.

Patched the mysql and right now I'm generating keyword reports. I'll give you feedback about the results.
Meanwhile I was studying the changed files.

I think this need to be added to the mysql patch:

Code: Select all

DROP TABLE IF EXISTS `themes`;

Grr, no BBCode.

Karel thanks for your comments. i disabled BBC code because there is lots of spammers in this forum

[seopanel_forum]

No edit button.

Here is the promised feedback.
Ran Seo Tools Generate Keyword Reports for all sites and only for the google searchengine.

Never saw "Keyword not assigned to required search engines........" message before, but then again I always rely on my cronjob. The cronjob runs only once during the night.

I've got about 875 keywords to crawl, only 25% was successfully crawled.

If I remember correctly, generating keyword reports and executing the cron, multiple times skips the successfully crawled keywords. So I may be forced to do just that. In previous versions this wasn't necessary.

yes better use following methods to get efficient reports, if you have so many keywords to track

http://forum.seopanel.in/viewtopic.php?f=11&t=3978

[francoeme]

Please do following steps

http://forum.seopanel.in/viewtopic.php?f=6&t=3871

Its an issue with mysql connection.

Thank you for you help.

I change this, but the error persist.

I can see in Report Generation Manager:

Starting keyword position checker cron for website: mywebsite.com....
Successfully crawled keyword MyKeyword results from www.yahoo.com.....
The database tables could not be found.
Click here to install Seo Panel.

I appreciate your help.
Thank you

[seopanel_forum]

It seems an issue with mysql connection, mysql connection lost during execution of cron script. thats why it is showing this error.

Can you please contact your web hosting about this issue and check is there is any timeout issues with mysql?

Please update their reply here.

[francoeme]

Hello.

I fix this problem. I did what you indicate here:

http://forum.seopanel.in/viewtopic.php?f=6&t=4527

Thank you