10 years ago
5
Topic
Hey guys, i'm trying to add a new website but when i go to construction > sites i get this error:
SQL=SELECT COUNT(a.id) FROM j2itz_cck_core AS a LEFT JOIN j2itz_content AS b ON b.id = a.pk WHERE a.storage_location = "joomla_article" AND b.access IN (27,);
Anyone have an idea of why this is happening?
SQL=SELECT COUNT(a.id) FROM j2itz_cck_core AS a LEFT JOIN j2itz_content AS b ON b.id = a.pk WHERE a.storage_location = "joomla_article" AND b.access IN (27,);
Anyone have an idea of why this is happening?
10 years ago
0
Level 1
i don't understand where the IN 27, does anyone know anything about this?
4229 Posts
10 years ago
1
Level 1
Hi,
this looks like joomla access error, like viewlevel or usergroup set as acess to this item somehow got broken, try resaving your usergroups and access levels
this looks like joomla access error, like viewlevel or usergroup set as acess to this item somehow got broken, try resaving your usergroups and access levels
10 years ago
0
Level 2
Just saved everything, didn't help. Any other suggestions?
What i did notice is that the "," behind the 27 is a syntax error is that what could be causing this?
When i go into mysql and try out the error without the comma it has an output of 0 instead of an error.
What i did notice is that the "," behind the 27 is a syntax error is that what could be causing this?
When i go into mysql and try out the error without the comma it has an output of 0 instead of an error.
4229 Posts
10 years ago
1
Level 1
Hi,
check your viewlevels table for missing values or value like this in rules column [27,]
check your viewlevels table for missing values or value like this in rules column [27,]
10 years ago
0
Level 2
there are no empty values, i deleted anything that had a 27. Same error. anything else i can try?