Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

Adding Block Error

This topic is locked: you cannot edit posts or make replies.

 

Daggers
Quote
Posts: 87 Location: Manchester
Sat 13 Jan, 2007 19:46
Subject: Adding Block Error
Seeing as I cannot post in the bugs section, I will post it here.

I have just tried to add a new block to the home page, the block was called Users Visited.

When I try to add the block, I get a DB error as follows;

Code: [Download] [Hide] [Select]
Could not insert data into block variable table

DEBUG MODE

SQL Error : 1064 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 't visit the site', 'md_display_not_visit', '', '', '4', 'users_

INSERT INTO phpbb_cms_block_variable (bid, label, sub_label, config_name, field_options, field_values, type, block) VALUES ('23', 'Display users who did not visit', 'tick to display users who didn't visit the site', 'md_display_not_visit', '', '', '4', 'users_visited')

Line : 987
File : cms.php


This does not happen all the time, I have been able to add other blocks no problem, it just seems to be that particular block.

Anybody got any solutions for this one.

Profile PM   Website
Daggers
Quote
Posts: 87 Location: Manchester
Sat 13 Jan, 2007 20:32
Subject: Re: Adding Block Error
A Foot Note

Although when I tried to add this block I was presented with the above error, it appears that the block was still added to the home page and appears to be working.

I think that the error is relating to a missing argument in the sql query when probing the databse :|

Profile PM   Website
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Wed 31 Jan, 2007 02:11
Subject: Re: Adding Block Error
I have fixed it... in the meantime when you add a block click on the link you are presented before clicking anywhere else... :wink:

Profile PM   Website
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.4326s (PHP: 4% SQL: 96%)
SQL queries: 29 - Debug Off - GZIP Enabled