- b2evolution CMS Support Forums
- b2evolution Support
- General Support
- Help bug with SQL
1 roleclass Dec 15, 2016 15:17
Hi this is new clean installation with no addons, i have a bug and need help please to fix it:
Additional information about this error:
MySQL error!
Table 'ravengui_b2e757.evo_coll_settings' doesn't exist(Errno=1146)
Your query: Get the Blog(subscription collections) rows to load the objects into the cache by BlogCache->load_subscription_colls()
SELECT *
FROM evove_blogs
WHERE (blog_ID NOT IN (
SELECT cset_coll_ID
FROM evove_coll_settings
WHERE cset_name = "allow_subscriptions"
AND cset_value = 0
)
OR blog_ID NOT IN (
SELECT cset_coll_ID
FROM evove_coll_settings
WHERE cset_name = "allow_comment_subscriptions"
AND cset_value = 0
))
AND (( blog_ID NOT IN (
SELECT cset_coll_ID
FROM evo_coll_settings
WHERE cset_name = "allow_access"
AND cset_value = "members" ) )
OR ( blog_ID IN (
SELECT cset_coll_ID
FROM evo_coll_settings
WHERE cset_name = "allow_access"
AND cset_value = "members" )
AND (
(
SELECT bloguser_user_ID
FROM evove_blogusers
WHERE bloguser_blog_ID = blog_ID
AND bloguser_ismember = 1
AND bloguser_user_ID = 1 )
OR (
SELECT bloggroup_group_ID
FROM evove_bloggroups
WHERE bloggroup_blog_ID = blog_ID
AND bloggroup_ismember = 1
AND ( bloggroup_group_ID = 1
OR bloggroup_group_ID IN (
SELECT sug_grp_ID
FROM evove_users__secondary_user_groups
WHERE sug_user_ID = 1 ) )
LIMIT 1
)
) ))
ORDER BY blog_order ASC, blog_ID ASC
the error is in the page: */index.php?disp=subs
Table 'ravengui_b2e757.evo_coll_settings' doesn't exist
means an essential table of b2evolution is missing.It means b2evolution has not been properly installed or the database has been altered.
Also many other pages hsould have a problem, not just
?disp=subs
How di you install b2evolution?