PEAK XOOPS - Version 2.8 SQL errors 
Version 2.8 SQL errors
- You cannot open a new topic into this forum
- Guests cannot post into this forum
- depth:
- 0
Previous post
-
Next post
|
Parent
-
Children.1
|
Posted on 2005/1/4 19:44
jseymour
From: Gainesville Florida, USA
Posts: 40
From: Gainesville Florida, USA
Posts: 40
I did a module update to the latest version and it stopped showing my feeds. Went back to my modules and checked the settings, all seemed ok. So I hit update and refetch, got a red error banner on the page.
First I started PHP debug, got no output. Next I enabled SQL debug. When I tried to save changes or refetch I get the following red output:
Quote:
Any idea how to fix this?
Update: I checked the data base and this Quote: is not being inserted. Tried it manually too.
Still did not insert.
First I started PHP debug, got no output. Next I enabled SQL debug. When I tried to save changes or refetch I get the following red output:
Quote:
UPDATE xoops_xhld0 SET headline_name='@RISK: The Consensus Security Alert', headline_url='http://www.sans.org/newsletters/risk/display.php', headline_rssurl='http://www.sans.org/newsletters/risk/rss/', headline_syndication='RSS', headline_timeout='10', headline_allowhtml='0', headline_titlepattern='', headline_linkpattern='', headline_encoding='utf-8', headline_cachetime=3600, headline_asblock=1, headline_display=1, headline_weight=0, headline_mainimg=1, headline_mainfull=1, headline_mainmax=25, headline_blockimg=1, headline_blockmax=7, headline_xml = '', headline_updated=0 WHERE headline_id=1
Error number: 1054
Error message: Unknown column 'headline_timeout' in 'field list'
Any idea how to fix this?
Update: I checked the data base and this Quote:
headline_timeout smallint(3) NOT NULL default '99',
Still did not insert.
Votes:0
Average:0.00
- depth:
- 1
GIJOE
Posts: 4110
Posts: 4110
hi jseymour.
It is a bug of 2.80
I've just made 2.81.
Update the module after overwriting it.
If it does work well, the structure of table xhld* is unexpected one. It is necessary to uninstall and install again. sorry.
Anyway, thank you for the reporting.
It is a bug of 2.80
I've just made 2.81.
Update the module after overwriting it.
If it does work well, the structure of table xhld* is unexpected one. It is necessary to uninstall and install again. sorry.
Anyway, thank you for the reporting.
Votes:0
Average:0.00
- depth:
- 2
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2005/1/5 10:12
jseymour
From: Gainesville Florida, USA
Posts: 40
From: Gainesville Florida, USA
Posts: 40
The update worked perfectly, as usual GIJOE. Thanks for the update and your modules.
I like the red tables in the list feeds page until they are updated, then they turn grey. Nice visual reference.
I like the red tables in the list feeds page until they are updated, then they turn grey. Nice visual reference.
Votes:0
Average:0.00
Login