Elxis CMS Forum
Support => General => Topic started by: kultsound on December 25, 2008, 23:42:28
-
Starting from scratch, making up a blog followed by a link to it I get the following errors on clicking it.
---------------------------------
mysql Error [1054] : EXECUTE
URI: index.php?option=com_eblog&task=browse&blogid=3&Itemid=115
Message: Unknown column 'b.published' in 'where clause'
SELECT b.* FROM elx_eblog b WHERE b.blogid='3' AND b.published='1' AND ((b.language IS NULL) OR (b.language LIKE '%english%')) ORDER BY b.dateadded DESC LIMIT 0,10
Test
Testing the blog
Peter A. Mankowski
Control panel
mysql Error [1054] : EXECUTE
URI: index.php?option=com_eblog&task=browse&blogid=3&Itemid=115
Message: Unknown column 'published' in 'where clause'
SELECT dateadded FROM elx_eblog WHERE blogid='3' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY dateadded DESC
-----------------------------------------------------
It was working fine in the the last version but now no matter how I go about it it seems something is broken in the script itself...
Please help,
Peter/42live
-
Hi kultsound, and welcome
It seems to me that you have applied the patch for 2245, but you forgot to read README.TXT
In that file it says you need to add one column, and how to do it...
-
HI Ivan,
Thanks for the welcome! Now, I did read the readme.txt that came with the zip, or to be exact the one contained in the root directory of the zip but nothing mentioned there so I'm not really sure where to find this specific readme?? ???
//peter
Hi kultsound, and welcome
It seems to me that you have applied the patch for 2245, but you forgot to read README.TXT
In that file it says you need to add one column, and how to do it...
-
Copy from the README.TXT which is included inside the update patch (elxis_patch_2008.1_r2204_r2245.zip) :
* DATABASE *
A new column has been added to table #__eblog. You have to create this column manually.
Go to your database manager (phpmyadmin if your database is mysql, pgmyadmin if it is postgresql, or to your oracle database manager).
Execute the following SQL command
For mySQL databases:
ALTER TABLE `elx_eblog` ADD COLUMN `published` TINYINT(2) UNSIGNED NOT NULL DEFAULT 1 AFTER `tags`;
For postgreSQL databases:
ALTER TABLE elx_eblog ADD COLUMN published smallint NOT NULL DEFAULT 1;
Replace "elx_" with your own database table prefix if it is different.
!! IMPORTANT !!
If you dont update your database eBlog will not work properly!
-
Great! Thank you very much!! It all works fine now!!! ;D Oh, and did I mention that elxis rocks?? ;)
//peter