Home Private Messages Search
CPG Dragonfly™ CMS stopsoftwarepatents.eu petition banner
Toggle Content
 
Forums ⇒ DragonflyCMS ⇒ Problems AFTER Install/Upgrade :: Archives ⇒ [fixed]database error has occurred -admin/modules/blocks.php :: Archived


[fixed]database error has occurred -admin/modules/blocks.php :: Archived
Issues that happen after DragonflyCMS upgrade/install.
DO NOT post module installation issues here!

Go to page Previous  1, 2
Post new topic    Revive this topic    Printer Friendly Page     Forum Index ⇒  Problems AFTER Install/Upgrade

Topic Archived View previous topic :: View next topic  
Author Message
mario
Nice poster
Nice poster

Offline Offline
Joined: Sep 14, 2004
Posts: 67
Location: Duiven, The Netherlands
PostPosted: Tue Feb 06, 2007 12:12 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

Ah, okay, tnx, as Nanocairdo gave a link to Blocks.php in CVS I didn't know which one to choose, so obviously I took the wrong, works okay now.


mario's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 1.3.33 / 4.0.25 / 4.3.11 / Dragonfly 9.0.6.01 and testsite, specs as before however with Dragonfly 9.1.1
Back to top
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
PostPosted: Tue Feb 06, 2007 12:26 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

np - understandable mix up - links fixed Smile

_________________
DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
harshmage
Newbie
Newbie

Offline Offline
Joined: Jan 26, 2007
Posts: 8
Location: Arizona, USA
PostPosted: Wed Feb 14, 2007 4:08 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

Okay, first time I've begun posting here, but this is the only problem I have. I have uploaded the .27 version of blocks.php to my admin/modules directory, and the error of moving blocks is gone, but the Right side blocks do not show.

www.harshmage.com/drag.../index.php

I've checked all my settings, and installed fresh several times now, and even utilized PostgreSQL for my db. Nothing works, though center blocks and left blocks work. Is there another thread I should be scouring?

_________________
-Bryan Witherspoon-
www.harshmage.com/
www.ninthchevron.com/

harshmage's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
*nix/1.3.37/4.1.21/4.4.4/9.1.1
Back to top
View user's profile Visit poster's website ICQ Number AIM Address MSN Messenger Yahoo Messenger
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
PostPosted: Wed Feb 14, 2007 4:27 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

Just your main page?
- dragonflycms.org/FAQ/cat=11.html#69

After you have added a new module?
- check what modules are allocated to your blocks in admin.php?op=blocks.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
harshmage
Newbie
Newbie

Offline Offline
Joined: Jan 26, 2007
Posts: 8
Location: Arizona, USA
PostPosted: Wed Feb 14, 2007 5:03 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

My apologies for not looking at the FAQ before posting. Thank you, Phoenix, for pointing it out to me, and teaching me a valuable lesson. I need to go back and watch "Posting and You!" again.

_________________
-Bryan Witherspoon-
www.harshmage.com/
www.ninthchevron.com/

harshmage's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
*nix/1.3.37/4.1.21/4.4.4/9.1.1
Back to top
View user's profile Visit poster's website ICQ Number AIM Address MSN Messenger Yahoo Messenger
xxiis.com
Newbie
Newbie

Offline Offline
Joined: Feb 13, 2007
Posts: 41
Location: Providence, RI
PostPosted: Mon Feb 19, 2007 6:04 pm
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

Okay, this fix worked perfectly, EXCEPT:

I happen to like my admin blocks on the right. So I changed my Admin block to show on the right.

But when I do change it and I click on Administration, the block disappears completely while in Administration Menu.

It works fine on the main site pages, but the moment you switch to Administration Menu it disappears.

Of course, the top menus etc work just fine, it's just the Admin block I can adjust it easier and put common things in there.

Any Ideas?

_________________
Login to xxiis.com without registering using : testuser/testuser

XXIIs.com, the storytelling site. Get paid to share your stories. Kids, teens, adult, etc. Weekly or Monthly serials delivered to your Inbox. Join today!

xxiis.com's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FreeBSD-5.5p1/1.3.37(Unix)/5.0.33-log/5.2.0/9.1.1
Back to top
View user's profile Visit poster's website
ithelp
Newbie
Newbie

Offline Offline
Joined: Jan 27, 2007
Posts: 21
Location: CA
PostPosted: Sun Feb 25, 2007 2:39 am
Post subject: Position of Blocks (Left Right)

Hello,

I am trying to change the position of the blocks. (the menu)
For example when I click on edit, "Coppermine Stats" and I change the position from Left to Right and then I save. I get the following error message.

A database error has occurred

includes\db\db.php

CMS Warning line 75: On /admin.php?op=blocks&save=4 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: C:\Inetpub\wwwroot\viaverdehoa\Dragonfly9\html\admin\modules\blocks.php on line: 460

Thanks a lot for your help.


ithelp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Windows 2003/IIS6/MYQL5.0.11/PHP4.4.4/DF9.1.1.1
Back to top
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: Sun Feb 25, 2007 2:58 am
Post subject: Re: Position of Blocks (Left Right)

There was a bug in the release, please see this sticky: dragonflycms.org/Forum...18049.html

_________________
Diagon Alley - Top Design

sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
Back to top
View user's profile Send e-mail Visit poster's website
mpyusko
Newbie
Newbie

Offline Offline
Joined: Mar 09, 2007
Posts: 34
Location: USA
PostPosted: Fri Mar 09, 2007 6:56 pm
Post subject: Re: Moving block left to the right

NanoCaiordo wrote:
http://dragonflycms.org/cvs/html/admin/modules/blocks.php?v=9.27

I have the error moving from left to right, now there is no error.

But now there is still no right columm displayed on my site even using the default Theme.


mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
ccrngd1
Newbie
Newbie

Offline Offline
Joined: Apr 27, 2007
Posts: 2

PostPosted: Fri Apr 27, 2007 1:49 am
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks

I do not receive any error messages, and all of the blocks seems to appear in the admin console editing widonw. However, I am having a similar problem that when I assign a block to display on the right, it doesnt do it.

I have re-uploaded the theme folders (4), the admin/module/blocks.php file from the cvs repository and no matter what theme I use, no block shows up on the right hand side.

I am sorry if I have overlooked the answer else where, but I have looked around and not seen this particular problem elsewhere on the forums.


ccrngd1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
?/?/5/4.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Phoenix
• Many Posts •
• Many Posts •

Offline Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
PostPosted: Fri Apr 27, 2007 1:55 am
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks

Phoenix wrote:
Just your main page?
- dragonflycms.org/FAQ/cat=11.html#69

After you have added a new module?
- check what modules are allocated to your blocks in admin.php?op=blocks.

_________________
DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website Photo Gallery
ccrngd1
Newbie
Newbie

Offline Offline
Joined: Apr 27, 2007
Posts: 2

PostPosted: Fri Apr 27, 2007 3:35 am
Post subject: Re: [fixed]database error has occurred -admin/modules/blocks.php

Wow, that was simple...very sorry again, but thanks for help.


ccrngd1's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
?/?/5/4.4/9.1.2.1
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic    Revive this topic    Printer Friendly Page    Forum Index ⇒  Problems AFTER Install/Upgrade
Page 2 of 2
All times are GMT
Go to page Previous  1, 2

Archive Revive
Username:
This is an archived topic - your reply will not be appended here.
Instead, a new topic will be generated in the active forum.
The new topic will provide a reference link to this archived topic.
 
   Toggle Content User Info

Welcome Anonymous

Nickname
Password
(Register)

   Toggle Content Last CVS commits
· Fixed .ico Expires header.
· Removed domain name from cookies so subdomains wont access them anymore.
· CSS and JS, case insensitives.
· CSS and JS, send correct HTTP 1.1 headers and fixed issues where themes and...
· Further security class improvements.
· 301 redirects on LEO changes
· Option to force 3xx http status codes
· Validate googlebot.com and google.com crawlers.
· CCBot
· Rss with etag and atom.

read more...

   Toggle Content Community

Support for DragonflyCMS in a other languages:

Deutsch
Español

   Toggle Content X-links
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
Interactive software released under GNU GPL, Code Credits, Privacy Policy