Page 1 of 4

Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Thu Nov 22, 2012 9:40 pm
by 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 :)

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Sat Nov 24, 2012 11:02 am
by 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.

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Sat Nov 24, 2012 1:31 pm
by 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.

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Nov 28, 2012 3:56 pm
by 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?

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Nov 28, 2012 8:18 pm
by seopanel_forum
francoeme wrote: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.

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Nov 28, 2012 8:20 pm
by seopanel_forum
Karel wrote: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: 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 :)

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Nov 28, 2012 8:22 pm
by seopanel_forum
Karel wrote: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

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Nov 28, 2012 8:46 pm
by francoeme
seopanel_forum wrote: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

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Thu Nov 29, 2012 8:36 pm
by 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.

Re: Seo Panel patch files for 3.3.0 - hot fixes released

PostPosted: Wed Dec 12, 2012 2:50 pm
by francoeme
Hello.

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

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

Thank you