Recent Topics

Help bug with SQL

Started by on Dec 15, 2016 – Contents updated: Dec 26, 2016

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

Dec 26, 2016 07:59

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?


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.