Hi

I'm getting database error when I click the News

---------------------------------------------------------------------------------------------

Database error in mysite.com

Query:

SELECT
	               
	               `te`.`id` AS `id`,
	               `te`.`caption` AS `caption`,
	               `te`.`snippet` AS `snippet`,
	               `te`.`content` AS `content`,
	               `te`.`when` AS `when_uts`,
	               DATE_FORMAT(FROM_UNIXTIME(`te`.`when`), '%Y-%m-%d %H:%i:%S') AS `when`,
	               DATE_FORMAT(FROM_UNIXTIME(`te`.`when`), '%d.%m.%Y') AS `when_uf`,
	               `te`.`uri` AS `uri`,
	               `te`.`tags` AS `tags`,
	               `te`.`categories` AS `categories`,
	               `te`.`comment` AS `comment`,
	               `te`.`vote` AS `vote`,
	               `te`.`date` AS `date`,
	               `te`.`status` AS `status`,
	               `te`.`featured` AS `featured`,
	               `te`.`cmts_count` AS `cmts_count`
                FROM `bx_news_entries` AS `te`
                WHERE 1  AND `te`.`status`='0' AND `te`.`featured`='1'
                ORDER BY `te`.`when` DESC LIMIT 0, 10

Mysql error: Unknown column 'te.snippet' in 'field list'

Found error in the file '/home/XXXX/public_html/XXXX/inc/classes/BxDolTextDb.php' at line 112.
Called 'getAll' function with erroneous argument #.

Can some one tell me how to fix this

D7.0.3 upgrade adds a new column 'snippet' to the 'entries' table of the news module, seems you don't have it..you can run this sql and it should resolve the issue -

ALTER TABLE `bx_news_entries` ADD `snippet` text NOT NULL AFTER `caption`;

Thank's  a lot mods4dolphin

I got it working

but I'm having the same problem for articles

can I do the same for articles or diferent sql

News >> ALTER TABLE `bx_news_entries` ADD `snippet` text NOT NULL AFTER `caption`;

Articles >> ALTER TABLE `bx_articles_entries` ADD `snippet` text NOT NULL AFTER `caption`;

Yes, that should work fine for articles too...

I did but i'm getting this

#1146 - Table 'XXX_XXX.bx_articles_entries' doesn't exist

ALTER TABLE `bx_articles_entries` ADD `snippet` TEXT NOT NULL AFTER `caption` ;

any idea

Try to run the install.sql that's part of the 7.0.3 upgrade package under files/modules/articles/install

Hi

when I go to >>  upgrade/files/7.0.2-7.0.3/modules/articles

I only see sql

no install.sql

yeah, try executing that...

Yea I did that but I get this

Error
SQL query:

ALTER TABLE `[db_prefix]entries` ADD `snippet` TEXT NOT NULL AFTER `caption` ;

MySQL said:

#1146 - Table 'xxxxxxxxx_xxxxxxx.[db_prefix]entries' doesn't exist

Thank's for helping to fix the other one but this one is driving me nuts

Funny. When I visit this thread, I'm presented with the login box for UFO360's cPanel.

Change db_prefix to bx_articles_

And I am also getting your site's cPanel login box like magnusoft, lol that's funny :D

Thank's for telling me guys

but I can't edit my post can any admin edit this for me

Thank's a lot

It shouldn't really be a problem. It does show your site's address, though. I've reported the posts that seems to be causing it. This happened because of the content you copied from phpMyAdmin.

I'm still can get it to work

__________________________

Error
SQL query:

ALTER TABLE  `[bx_articles_]entries` ADD  `snippet` TEXT NOT NULL AFTER  `caption` ;


MySQL said:

#1146 - Table 'xxxxxxxxxx_xxxxxxxxxxxxxx.[bx_articles_]entries' doesn't exist

____________________________

Yea I need my post to be fix  please

ALTER TABLE  `bx_articles_entries` ADD  `snippet` TEXT NOT NULL AFTER  `caption` ;

Wow this one is driving me nuts and nuts

I add this like you tell me

ALTER TABLE  `bx_articles_entries` ADD  `snippet` TEXT NOT NULL AFTER  `caption` ;

UPDATE `sys_modules` SET `version` = '1.0.3' WHERE `uri` = 'articles' AND `version` = '1.0.2';

Them i try this

ALTER TABLE  `[bx_articles_entries]` ADD  `snippet` TEXT NOT NULL AFTER  `caption` ;

UPDATE `sys_modules` SET `version` = '1.0.3' WHERE `uri` = 'articles' AND `version` = '1.0.2';

and still not working I don't now why I keep getting the same error

Thanks a lot for all the help mods4dolphin

I got it working

Thank's man

Glad to know you got it working :)