Icy Phoenix :: View topic - Adding Block Error

Daggers [ Sat 13 Jan, 2007 19:46 ]
Post 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: [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.

Daggers [ Sat 13 Jan, 2007 20:32 ]
Post 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 :|

Mighty Gorgon [ Wed 31 Jan, 2007 02:11 ]
Post 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:

Icy Phoenix

Old Support Topics - Adding Block Error