[Anja]

Good evening,

I installed the most recent Content (Enhanced) module for a gaming site, and have run into problems creating pages via the admin menu. I am able to create categories just fine, but as soon as I submit a new page, regardless of content, I get an error page that reads:

A database error has occurred
The webmaster has been notified of the error

I am the webmaster, and do not receive any such email. (p.s. email is confirmed to work through the site via the Contact Us module).

Anyway. I tried uninstalling it and using the latest "standard" Content module, which works perfectly. If I then try to upgrade to Content (Enhanced) with existing categories and pages in place (vs. the clean install mentioned above), I again find myself able to create new categories, but unable to create new pages.

Again, I am not receiving the error notice so I don't have much to work with. If anyone has any ideas on how to fix this issue, I would greatly appreciate it!

[dISmAG]

same problem I upgraded and got the problem when trying to create the page

=============== also in debuge=======
modules/Content/admin/index.inc
Warning line 67: Missing argument 1 for content_save()
includes/db/db.php
CMS Warning line 51: On /admin.php?op=Content&mode=content_save While executing query "INSERT INTO cms_pages SET cid='1', title='Всем привет', subtitle='Всем привет', active='0', page_header='Всем привет', text='Всем привет', page_footer='Всем привет', signature='Всем привет', date=now(), counter='0', language='russian')" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 In: /home/koresara/public_html/modules/Content/admin/index.inc on line: 95

[darkgrue]

Anja wrote:

Good evening,

I installed the most recent Content (Enhanced) module for a gaming site, and have run into problems creating pages via the admin menu. I am able to create categories just fine, but as soon as I submit a new page, regardless of content, I get an error page that reads:

A database error has occurred
The webmaster has been notified of the error

I am the webmaster, and do not receive any such email. (p.s. email is confirmed to work through the site via the Contact Us module).

The Content module doesn't send that error e-mail, the error handler in the core does. And just decause the Contact Us module sends e-mail doesn't mean the error handler can. If you're not getting the e-mail, you have a local configuration or e-mail routing problem that's outside of the scope of the module, I'm afraid.

dISmAG wrote:

same problem I upgraded and got the problem when trying to create the page

=============== also in debuge=======
modules/Content/admin/index.inc
Warning line 67: Missing argument 1 for content_save()
includes/db/db.php
CMS Warning line 51: On /admin.php?op=Content&mode=content_save While executing query "INSERT INTO cms_pages SET cid='1', title='Всем привет', subtitle='Всем привет', active='0', page_header='Всем привет', text='Всем привет', page_footer='Всем привет', signature='Всем привет', date=now(), counter='0', language='russian')" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 In: /home/koresara/public_html/modules/Content/admin/index.inc on line: 95

You are probably both having the same problem - there's a stray ")" in the DB query that's causing the error. In file modules/Content/admin/index.inc, change Line 95 from:

PHP:

SET cid='$cid', title='$title', subtitle='$subtitle', active='$active', page_header='$page_header', text='$text', page_footer='$page_footer', signature='$signature', date=now(), counter='0', language='$language')", FALSE);

to:

PHP:

SET cid='$cid', title='$title', subtitle='$subtitle', active='$active', page_header='$page_header', text='$text', page_footer='$page_footer', signature='$signature', date=now(), counter='0', language='$language'", FALSE);

I'm in the process of uploading version 9.7.5, which will include this fix. Thank you for reporting the problem!

[Anja]

Works great now! Thanks

[rosbif]

I actually found that error on line 94 - on a line that said:

PHP:

VALUES NULL, '$cid', '$title', '$subtitle', '$active', '$page_header', '$text', '$page_footer', '$signature', now(), '0', '$language'", FALSE);

Hope that's right!?

[darkgrue]

rosbif wrote:

I actually found that error on line 94 - on a line that said:

PHP:

VALUES NULL, '$cid', '$title', '$subtitle', '$active', '$page_header', '$text', '$page_footer', '$signature', now(), '0', '$language'", FALSE);

Hope that's right!?

Yes, that's correct. I may have miscounted lines by 1. It's the same file, same stray right parenthesis. What happened was I changed the SQL statement from a VALUES list (which has to be in the exact order and number of arguments as the database schema) to a SET statement that explicitly enumerates the column names. It was a stylistic change to make the code more maintainable, but I forgot to edit out the closing parenthesis from the VALUES list, which caused the problem.

[ostvard]

Hi,
After downloading and installing 9.7.5 I was getting the following error.

modules\Content\admin\index.inc

* Warning line 67: Missing argument 1 for content_save()

includes\db\db.php

* CMS Warning line 51: On /admin.php?op=Content&mode=content_save While executing query "INSERT INTO cms_pages SET cid='0', title='qw', subtitle='', active='0', page_header='', text='p>Balinese', page_footer='', signature='', date=now(), counter='0', language='english'"
the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's' at line 2 In: D:\Inetpub\wwwroot\KittyCatPics\modules\Content\admin\index.inc on line: 95

Checked for the extra ")" which was not there. The problem seemed to be with a ".

Checked index.inc and found the following fix.

change line 74 from

Code:

//   $text = Fix_Quotes($_POST['text']);

to

Code:

$text = Fix_Quotes($_POST['text']);

change line 75 from

Code:

$text = $_POST['text'];

to

Code:

//   $text = $_POST['text'];

Hope it helps.

[darkgrue]

I apologize for that. That was a temporary change I made for testing. I packaged and uploaded the wrong version. I'm working on 9.7.6 to fix this, but I'm setting it aside a day or two to take a little extra time off of it before I start testing it again.