Can't use apostrophes in Group meta keywords fields?

Post all bugs here
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by admin »

So what's the name of that field in the table purpose of which you do not understand ?
I guess It is pretty hard to misunderstand names like 'name, description' and so on

Models - ok, explain plz how to repeat that problem and i'll fix it.
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by SpyCam »

There is no cell names in table, so i don't know which cell is for which value, this is the problem. I understand the meanings, i don't understand the sequence of them in the table's columns.
I need you to explain which column is for which value.

Will get back to models when this table is fixed first.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by admin »

but you told me you have that table ?
at lease you have it in backup and so on ..

CREATE TABLE `rot_groups_data` (
`site_id` int(10) unsigned NOT NULL DEFAULT '0',
`group_id` int(11) NOT NULL DEFAULT '0',
`custom_name` varchar(50) NOT NULL,
`description` varchar(255) NOT NULL,
`group_keywords` varchar(255) NOT NULL,
`keywords` text NOT NULL,
`group_custom_var1` text NOT NULL,
`group_custom_var2` text NOT NULL,
`group_custom_var3` text NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
KEY `site_id` (`site_id`,`group_id`)
)
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by SpyCam »

I have old version of table, without custom vars filled.
and in table it is not marked how each column is named ;)

Thanks
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by admin »

in table it is not marked how each column is named ;)
In fact it is named and marked ...
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by SpyCam »

In the exports to CSV that I could open and edit in excel, i couldn't find any column names.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Can't use apostrophes in Group meta keywords fields?

Post by admin »

Yes, but that doesn't mean fields are not named in mysql.
Don't forget to run script update
Post Reply