Articles - Database error

My site is stable and working well (well I thought it was). Today though, i tried to add a new article. The last time I did so it worked perfectly. So I really wonder why all of a sudden I get this database error that even keep me from adding a new text... Someone has an idea?

Database error in mysite!

Query:

SELECT ArticleUri AS Uri FROM Articles WHERE ID='25'

Mysql error:

Unknown column 'ID' in 'where clause'

Found error in file /pathblablabla/inc/classes/BxDolArticles.php

at line 604. Called db_arr function

with erroneous argument #0

Debug backtrace:

Array

(

[1] => Array

(

[file] => /pathblablabla/inc/db.inc.php

[line] => 115

[function] => db_res

[args] => Array

(

[0] => SELECT ArticleUri AS Uri FROM Articles WHERE ID='25'

[1] => 1

)

)

[2] => Array

(

[file] => /pathblablabla/inc/classes/BxDolArticles.php

[line] => 604

[function] => db_arr

[args] => Array

(

[0] => SELECT ArticleUri AS Uri FROM Articles WHERE ID='25'

)

)

[3] => Array

(

[file] => /pathblablabla/admin/articles.php

[line] => 85

[function] => ActionAddUpdateElements

[class] => BxDolArticles

[object] => BxDolArticles Object

(

[bAdminMode] => 1

[sCurrBrowsedFile] => /admin/articles.php

[iVisitorID] => 0

[sUrl] => http://mysite.com/admin/

)

[type] => ->

[args] => Array

(

)

)

[4] => Array

(

[file] => /pathblablabla/admin/articles.php

[line] => 74

[function] => getArticlesAdminContent

[args] => Array

(

[0] => Array

(

[admin] => 1

)

)

)

)

Called script: /admin/articles.php

Quote · 29 Jul 2009

inc/classes/BxDolArticles.php at line 604

Find ID

change to

ArticlesID

I dont know what your looks like but it should look like:

$sArticleUri = db_value("SELECT `ArticleUri` FROM `Articles` WHERE `ArticlesID`='{$iArticleId}'");

I have video tutorials to help you mrpowless.com
Quote · 29 Jul 2009

Hello MrPowless,

I have the same as you, Article ID and

$sArticleUri = db_value("SELECT `ArticleUri` FROM `Articles` WHERE `ArticlesID`='{$iArticleId}'");

I noticed though that the aticle was posted...it's just that I receive the error message anyway.

Quote · 29 Jul 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.