Posted on: 02/17/08 07:01am
By: Anonymous (sunny)
I am facing problems with RSS and Search
1. The search only shows latest postings. (I upgraded to 1.4.1) also changed servers. I used a backup to restore the database.
2. I see no RSS option... (content syndication is missing)
Please help
site: onlygizmos . com
Re: RSS and search error
Posted on: 02/17/08 07:29am
By: Dirk
Which version did you upgrade from? Did you run the install script in upgrade mode afterwards? Or did you use Fantastico or some other software provided by your hosting service?
It seems other people had
similar problems[*1] in the past, due to faulty updaters (over which we have no control).
bye, Dirk
Re: RSS and search error
Posted on: 02/18/08 12:58am
By: Anonymous (sunny)
Hi there
Thx for the quick reply.
Actually i did a fresh install and used the backup database file to update it.
However i wasnt techie enough to understand all that i did. Is there anyway we can get it fixed?
Specially the search part
Re: RSS and search error
Posted on: 02/18/08 04:07am
By: Dirk
Quote by: sunnyActually i did a fresh install and used the backup database file to update it.
And was the backup from the same version? If not (e.g. using a 1.4.0 backup with a fresh 1.4.1 install), you still need to run the install script over it once (to update the database).
bye, Dirk
Re: RSS and search error
Posted on: 02/18/08 08:31am
By: Anonymous (sunny)
Hi
the backup from was an older version
I actually used fantastico for upgrade...
Shall i do a manual install now over this current install? And will i need to manually restore database and images ?
If its not too much of a trouble can you give me the steps (need not be detailed)
Will this also activate the search again?
Regards
An kur
Re: RSS and search error
Posted on: 02/22/08 03:30pm
By: Anonymous (sunny)
Ok i ran an upgrade on the site. This updated the Database and resolved the search issue.
but the syndication issue remains as the content syndication icon dosent show up ....
any solutions ??
Re: RSS and search error
Posted on: 02/22/08 03:43pm
By: Dirk
In Geeklog 1.4.1, there's a new permission for the Syndication panel. In 1.4.0, you had to be in the Root group to get access to it, in 1.4.1, there's a Syndication Admin group and a syndication.edit permission. Those are added during the update.
See if you have any of those.
Which update option did you use? Something provided by your hosting service or the tarball from geeklog.net?
bye, Dirk
Re: RSS and search error
Posted on: 02/24/08 01:14pm
By: Anonymous (sunny)
i downloaded 1.4.1 and installed again ...
during install i selected upgrade option (i was on 1.4.1 already) and at the end it gave some error ...
and then when i installed again it said that the database is already upgraded!
Re: RSS and search error
Posted on: 02/24/08 01:34pm
By: Anonymous (sunny)
"there's a Syndication Admin group and a syndication.edit permission. Those are added during the update." - it isnt showing
Re: RSS and search error
Posted on: 02/24/08 01:46pm
By: Anonymous (sunny)
as i go to http://mysite/admin/syndication.php
it gives error
Access Denied
Sorry, you do not have access to the link administration page. Please note that all attempts to access unauthorized features are logged
also my site was firsly in a subdomain geeks.mysite.com
and the a objective of the upgrade was also to bring the site to the main domain and also to change servers!
Re: RSS and search error
Posted on: 02/24/08 02:52pm
By: Dirk
Quote by: sunnyduring install i selected upgrade option (i was on 1.4.1 already) and at the end it gave some error ...
and then when i installed again it said that the database is already upgraded!
Do you have a backup from the old version (before the attempted update)?
And the next time you run into an error, please quote it here. It's hard to tell what's going on without detailed information.
bye, Dirk
Re: RSS and search error
Posted on: 02/25/08 08:55am
By: Anonymous (sunny)
Yes i might have it? but if i load that lot of newly added info will be lost.
Please advice. Shall i take a fresh backup and make a new install then restore it?
Re: RSS and search error
Posted on: 02/25/08 02:34pm
By: Dirk
The problem is that your database upgrade was faulty. We found one problem with it (the missing Syndication Admin). We don't know what else may be wrong with it.
I can tell you how to add the Syndication Admin. That will fix that problem but won't guarantee that there aren't other problems.
Your other option is to go back to the last backup before the failed upgrade, do the upgrade with your new install (and I'm sure it'll work this time) and then add whatever new content you added since then.
Let's check a few things before you make that decision:
Can you have a look at the database (using phpMyAdmin or CPanel or whatever's handy)? Check if there is a "Syndication Admin" entry in the gl_groups table. If there is, does it show up in Geeklog's "Groups" list (note that you need to check "Show Admin Groups" there first, then hit Submit).
Next, when you go to the Admin's "Plugins" panel, do any of the plugins show a note that they need to be upgraded?
And finally: Create a new "normal" block. Just enter something. Do you have an option "Autotags"? If so, check it and save the block. Does that work?
Just trying to get an idea what happened in your database ...
bye, Dirk
Re: RSS and search error
Posted on: 02/25/08 11:21pm
By: Anonymous (sunny)
oh i forgot to tell a few things,
i am facing some problems with blocks aswell ...
i get an error An SQL error has occurred. Please see error.log for details.
while i save or edit any block
.. Wil try the other suggestions shortly
Re: RSS and search error
Posted on: 02/25/08 11:42pm
By: Anonymous (sunny)
ok i am typing it as i try...
logged in to phpMyAdmin
I can see Syndication Admin in `gl_groups`
---------------
but not in the Groups Admin - it shows the following:
All Users
Calendar Admin
Links Admin
Logged-in Users
mediagallery Admin
mediagallery Config
Polls Admin
spamx Admin
Static Page Admin
---------------
As for the plugins: i dont really know how to check if they have to be upgraded. I am attaching a link to the screenshot below.
and as i said before i am unable to create any new block (as soon as i hit save, the sql error appears.)
Also i would like to get the Rss problem fixed at the moment (if possible Blocks aswell), but plz tell me will it be allright after i upgrade to the next release of geeklog?
Thx for all the help dirk ...
Re: RSS and search error
Posted on: 02/25/08 11:46pm
By: Anonymous (sunny)
http://farm4.static.flickr.com/3020/2292504513_7fa2e19887_o.jpg
Re: RSS and search error
Posted on: 02/26/08 01:53pm
By: Dirk
As I suspected - some things have been updated and others haven't.
The SQL error is due to a missing update to the gl_blocks table. Check your error.log. It's probably complaining about a missing field "allow_autotags".
The cleanest solution at this point would be to do the upgrade again using your old (pre-upgrade) database backup. Someone familiar with SQL could probably repair things, but that would require some work.
bye, Dirk
Re: RSS and search error
Posted on: 02/26/08 04:41pm
By: Anonymous (sunny)
there is no mention of autotags in the error log.
instead wht i read is:
Wed 27 Feb 2008 00:16:19 IST - Media Gallery Error - Invalid album_id passed to album.php
--------
Tue 26 Feb 2008 22:56:31 IST - Error communicating with SLV: Connection timed out; Message was (@xml version="1.0" encoding="UTF-8"@)
<methodCall>
-------
here is a screen shot for better understanding:
http://farm4.static.flickr.com/3111/2294042773_d8fe1c358e_o.jpg
Re: RSS and search error
Posted on: 02/26/08 04:45pm
By: Anonymous (sunny)
Adding all the content with Media Gallery will be virtually impossible. Its too much to do manually.
Can we downgrade the version of geeklog? or simply wait for a new version (1.4.2)??
Or shall i try using a fresh backup of the database and loading it on a geeklog with media gallery preinstalled to see if it works?
Re: RSS and search error
Posted on: 02/26/08 06:03pm
By: jmucchiello
Quote by: sunnyAdding all the content with Media Gallery will be virtually impossible. Its too much to do manually.
How long has the system been damaged?
Re: RSS and search error
Posted on: 02/26/08 11:15pm
By: Anonymous (sunny)
I believe December
even media gallery was installed later.
Re: RSS and search error
Posted on: 02/26/08 11:20pm
By: Anonymous (sunny)
Is there any way i can hire a professional to repair the database? Thx
Re: RSS and search error
Posted on: 02/27/08 01:56am
By: Dirk
If most of the additional content is in Media Gallery, then you could do a "mix and match":
- export the current Media Gallery tables
- reinstall your old database backup
- run the upgrade
- put the exported Media Gallery tables back in
You should ask Mark for any input on this approach first, though, as there may be pitfalls here that I'm missing.
bye, Dirk
Re: RSS and search error
Posted on: 02/27/08 02:29pm
By: mevans
Dirk is right on track with his suggestion.
The 2 key items you want to preserve for Media Gallery is to dump all the mg_* tables including drop/create table statements and all data using a tool like phpMyAdmin. Also, make sure you preserve the public_html/mediagallery/mediaobjects/* directories, these contain your media items and is closely linked to the database entries.
So, export your mg_* tables, save a backup of the mediaobjects/* directories and then try your Geeklog install / upgrade again. Install Media Gallery (by copying the files to your server), run the plugin installer, then import your dumps via phpMyAdmin (since we included drop/create statements in the export it will remove and recreate all the Media Gallery tables with the necessary data). Then restore your mediaobjects/* directories and you should be in business.
Let me know if you need any more help.
Thanks!
Mark
Re: RSS and search error
Posted on: 02/28/08 01:26am
By: Anonymous (sunny)
Thx Mark,
So shall i first backup Media gallery , then uninstall it and then upgrade Geeklog and then reinstall Mediagallery?
Shall we resolve the syndication issue after that?
i realised that i am registered as ankur_mmy on the forums. I will be using that ID next time.
Re: RSS and search error
Posted on: 03/03/08 05:02pm
By: ankur_mmy
SUNNY Here:
I tried several things. The good news is the Syndication is fixed.
The bad news is I couldnt upgrade as mentioned.
--------------------------
I got the autotags error Dirk was expecting in media gallery. (thats after i reinstalled media gallery)
Tue 04 Mar 2008 02:58:46 IST - 1054: Unknown column 'allow_autotags' in 'field list'. SQL in question: REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled,allow_autotags) VALUES (4,'polls_block','Poll','','phpblock','20','','all','','0000-00-00 00:00:00','0','phpblock_polls',1,2,1,3,3,2,2,1,0)
-----------------------------
I tried loading an older database version. The site went down with an AQL error. A database upgrade failed with an error 1060: duplicate..... (some entries)
------------------------------
So i loaded the current database again. Now i can shift the blocks up and down by editing the values in the database, but the admin panel on the site gives an SQL error whenever i try to edit a block. But the major concern of Syndication was resolved by creating a new group (in Groups Admin) which gave SpamX admin access to syndication edit and all the other fields ...
--------------------------------
I take this as a temporary solution. Atleast for the visitors the site is more or less error free. But my worries are far from over.
Can someone advise, if it would be a good idea to wait for Geeklog 1.4.2 and upgrade the database then? any more suggestion?
Thx
Re: RSS and search error
Posted on: 03/05/08 04:51pm
By: ankur_mmy
any more advice?
Re: RSS and search error
Posted on: 03/05/08 05:47pm
By: jmucchiello
Quote by: sunnyThx Mark,
So shall i first backup Media gallery , then uninstall it and then upgrade Geeklog and then reinstall Mediagallery?
Um, I think "upgrade Geeklog" should be "install a fresh version of Geeklog" Then reinstall MG and then restore from your backup of MG.
Re: RSS and search error
Posted on: 03/14/08 08:43am
By: Anonymous (Sunny)
I just realised that i was using Geeklog version1.4.0sr5-1 before, and there was a different file we had to use to upgrade form that version ... probably thats where the original problems started ... i am about to try a few new things :
1. Switching back to an older version and then upgrading with the correct file
2. trying to import only the stories from the current database file
(Medial gallery will also be installed and restored.)
Lets hope for the best
Regards