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;
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
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.