[fixed]database error has occurred -admin/modules/blocks.php :: Archived

Joos1991 · Newbie Offline Joined: Jan 09, 2007 Posts: 4

I have a problem, and i can't solve it:

Code::

admin/modules/blocks.php

    * Notice line 432: Undefined index: content
    * Notice line 433: Undefined index: url
    * Notice line 445: Undefined index: in_module
    * Notice line 460: Undefined variable: weight

includes/db/db.php

    * CMS Warning line 75: On /web/admin.php?op=blocks&save=2 While executing query "UPDATE cms_blocks SET weight=weight+1 WHERE weight>= AND bposition='r'" 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 'AND bposition='r'' at line 1 In: /home/railsimulatornl/HTML/web/admin/modules/blocks.php on line: 460

Running on MySQL 4.1.10

Phoenix · Posted: Tue Jan 09, 2007 4:19 pm Post subject: Re: A database error has occurred

Yes, there was a small error - please use this file,
dragonflycms.org/cvs/h...php?v=9.27

Joos1991 · Newbie Offline Joined: Jan 09, 2007 Posts: 4

Thanks, working fine now! Smile

BrokenCrust · 500+ Posts Club Offline Joined: Sep 06, 2004 Posts: 503

Moving a block from the right to the left (or I assume other editing of the block) throws an error. Also there are a bunch of notices

Code::

admin\modules\blocks.php

    * Notice line 432: Undefined index: content
    * Notice line 433: Undefined index: url
    * Notice line 445: Undefined index: in_module
    * Notice line 460: Undefined variable: weight

includes\db\db.php

    * CMS Warning line 75: On /admin.php?op=blocks&save=38 While executing query 
"UPDATE cpg_blocks SET weight=weight+1 WHERE weight>= AND bposition='l'" 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 
'AND bposition='l'' at line 1 In: c:\cpgtest\html\admin\modules\blocks.php on line: 460

NanoCaiordo · Posted: Thu Jan 11, 2007 8:55 pm Post subject: Re: Another block error 9.1.1

dragonflycms.org/cvs/h...php?v=9.27

BrokenCrust · 500+ Posts Club Offline Joined: Sep 06, 2004 Posts: 503

Sorted. Thank You.

mrnorton · Newbie Offline Joined: Jun 21, 2005 Posts: 8

When I tray to move a block from The left side to the right side I get follow message from debug.

On /admin.php?op=blocks&save=2
While executing query "UPDATE cms_blocks SET weight=weight+1 WHERE weight>= AND bposition='r'"

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 'AND bposition='r'' at line 1

Thanks

NanoCaiordo

dragonflycms.org/cvs/h...php?v=9.27

mrnorton · Newbie Offline Joined: Jun 21, 2005 Posts: 8

Thanks now it working.

ibnuahmad · Posted: Tue Jan 23, 2007 11:08 am Post subject: Error to change block Position

i'm try to change User info block Position, but Database error, warning massage :

includes/db/db.php

* CMS Warning line 75: On /v1/admin.php?op=blocks&save=2 While executing query "UPDATE cms_blocks SET weight=weight+1 WHERE weight>= AND bposition='r'" 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 'AND bposition='r'' at line 1 In: public_html/v1/admin/modules/blocks.php on line: 460

anybody now why?

Phoenix

Use the link in the second post of this topic.

ausindo · Newbie Offline Joined: Jul 31, 2006 Posts: 2

Hi

I got this error wheen changing block from left to right.
Any advise to fix this? Thank you

Code::

includes/db/db.php
CMS Warning line 75: On /admin.php?op=blocks&save=7 While executing query "UPDATE cms_blocks SET weight=weight+1 WHERE weight>= AND bposition='r'" 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 'AND bposition='r'' at line 1 In: /home/berkat/public_html/admin/modules/blocks.php on line: 460

Phoenix

your answer is right here.

mario · Posted: Tue Feb 06, 2007 11:13 am Post subject: Re: Another block error 9.1.1

BrokenCrust wrote:

Moving a block from the right to the left (or I assume other editing of the block) throws an error. Also there are a bunch of notices

Code::

admin\modules\blocks.php

    * Notice line 432: Undefined index: content
    * Notice line 433: Undefined index: url
    * Notice line 445: Undefined index: in_module
    * Notice line 460: Undefined variable: weight

includes\db\db.php

    * CMS Warning line 75: On /admin.php?op=blocks&save=38 While executing query 
"UPDATE cpg_blocks SET weight=weight+1 WHERE weight>= AND bposition='l'" 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 
'AND bposition='l'' at line 1 In: c:\cpgtest\html\admin\modules\blocks.php on line: 460

I got the same error as above, uploaded the latest CVS Blocks.php as stated in this post, no error after that however the block's list shows empty, as there wouldn't be installed one single block??

Phoenix

You shouldn't use the latest cvs file, otherwise you'll be needing others (like templates).

Please use the version stated or, use the full cvs snapshot which will soon be the next release.