Recent Topics

1 Nov 29, 2013 22:30    

Hi, I've spent hours reading and following messages similar to my issue in this forum to no avail. I'm using the most recent version of b2evolution on my website, 5.0.6, and a fairly new version of PHP, 5.3.27. All of a sudden, last Sunday when I woke up, I started getting the error listed above in the title, and I could not edit posts (wouldn't let me save anything). Most of my widgets completely disappeared off my site, with the exception of some plain text ones like Recent Comments. I noticed the posts had all these \\\ added in the beginning where the images are supposed to be.

I've tried every modification I've read about with _misc.funcs.php and more. Various modifications to htmlspecialchars within that file. I upgraded the version I had of b2evolution to the most recent one. I changed the character set to utf8 in locales.php. I've played around with .htaccess making various suggested changes. I've disabled the plugins folder and renamed TinyMCE and Captcha. And more....

My gut instinct tells me it's either something I need to change in _misc.funcs.php, something related to foreach (), or, the hosting provider needs to tweak something in their version of PHP (I suspect if they upgraded to a newer version it would fix the problem). I suspect the problem either developed because 1) I added a lot of code from statcounter.com right before it happened, or 2) the hosting provider must have just upgraded PHP Saturday overnight.

My site is intellectualconservative.com. Any ideas GREATLY appreciated.

2 Nov 29, 2013 23:20

Hi @az4vlad1,

Did you try removing all the code added from statcounter.com? The line 4542 at inc/_core/_misc.funcs.php on the standard release is not inside a foreach cycle, then we could infer you made some hacks in that file. Please do the following in order to discard one by one the possible source of this issue:

1) Try to get rid of all the non-standard code.
2) Disable all the plugins and widgets.
3) Change the skin to a standard one (could be evopress)
4) Enable the debugging and share its output

Regards !

3 Nov 29, 2013 23:55

Hi thanks, that was fast! I was able to enable debugging, but could not do any of the other steps because it will not allow me to save any changes I make in the dashboard, e.g. disabling plugins or widgets (I did rename the folder plugins to a-plugins when ftp'ing there), changing the skin, or deleting the statcounter code. It gives me that "incorrect crumb received!" error message when I try to save any changes. Also, when I upgraded b2evolution in hopes it would fix things, it now gives me this error in the dashboard, "Remote error: Received from server invalid compressed HTTP (104)" (which I see has been addressed in these forums before).

Here is the debug info it gives me:

Debug info
HTTP Response code: 200
$content_type_header: Content-type: text/html; charset=iso-8859-1
$disp: -- detail:
$robots_index:
$robots_follow:
74 SQL queries executed in 0.058 seconds scroll down to details

Timers
Category Time % Count
total 1.070 100.09% 1
SQL QUERIES 0.058 5.43% 74
abstractsettings_GeneralSettings_get 0.199 18.62% 18939
init modules 0.021 1.96% 1
evonet: check for updates 0.861 80.54% 2
shutdown 0.113 10.57% 1
+ 13 queries < 1%
Opcode cache: none

Memory usage: 22 MB
Memory peak usage: 30 MB
Len of serialized $cache_imgsize: 498
Len of serialized $cache_File: 2
Debug messages
error | _init_login | evonet | request | session | skins | timer
error:
Session: Session data corrupted!
connection_charset: 'latin1'
Serialized data was: --['a:1:{s:19:\\"crumb_latest_voting\\";a:2:{i:0;N;i:1;s:43:\\"EpdemIf16XPJuITQr5UpsNF3j13jjEW6-1385765575\\";}}']--
_init_login:
Login: login: NULL
Login: pass: empty
Login: Was already logged in... [rachelalexander]
evonet:
Getting updates from rpc.b2evo.net.
Getting updates from rpc.b2evo.net.
request:
vars: vars: Getting ReqURI from REQUEST_URI
vars: $ReqHost: http://intellectualconservative.com
vars: $ReqURI: /admin.php?blog=1
vars: $ReqPath: /admin.php
Hit: IP: 184.78.138.54
Hit: UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
Hit: Referer: 'http://intellectualconservative.com/index.php'; type=self
Hit: Remote Host:
Session: cookie_domain=.intellectualconservative.com
Session: cookie_path=/
Session: Session ID received from cookie: 24789014
Session: Session ID is valid.
Session: Session user_ID: '1'
Hit:detect_useragent(): Agent name: firefox
Hit:detect_useragent(): Agent platform: win
Session: Session data[crumb_latest_voting] updated. Expire in: -.
Hit: Hit NOT logged, (Admin page logging is disabled)
Session: Session data saved!
session:
Session: Session data corrupted!
connection_charset: 'latin1'
Serialized data was: --['a:1:{s:19:\\"crumb_latest_voting\\";a:2:{i:0;N;i:1;s:43:\\"EpdemIf16XPJuITQr5UpsNF3j13jjEW6-1385765575\\";}}']--
skins:
Using admin skin «chicago»
Admin-Path: array ( 0 => 'dashboard', )
timer:
total resumed at 0.000
_init_base resumed at 0.000
_init_base paused at 0.004 (+0.0044)
_init_db resumed at 0.000
_init_db paused at 0.006 (+0.0065)
init modules resumed at 0.000
init modules paused at 0.021 (+0.0207)
plugin_init resumed at 0.000
plugin_init paused at 0.000 (+0.0003)
_init_hit resumed at 0.000
Hit::get_remote_host resumed at 0.000
Hit::get_remote_host paused at 0.000 (+0.0000)
_init_hit paused at 0.006 (+0.0063)
_init_session resumed at 0.000
_init_session paused at 0.003 (+0.0030)
_init_login resumed at 0.000
_init_login paused at 0.009 (+0.0091)
_init_session resumed at 0.003
_init_session paused at 0.003 (+0.0000)
_init_hit resumed at 0.006
_init_hit paused at 0.006 (+0.0000)
Blog constructor resumed at 0.000
Blog constructor paused at 0.000 (+0.0001)
evonet: check for updates resumed at 0.000
evonet: check for updates paused at 0.750 (+0.7500)
shutdown resumed at 0.000
evonet: check for updates resumed at 0.750
evonet: check for updates paused at 0.861 (+0.1113)
DB

Config DB Username: intellec_ic
Config DB Database: intellec_bvlt1
Config DB Host: localhost
Config DB tables prefix: evo_
Config DB connection charset:

Current DB charset: latin1

DB queries: 74
Query #1: we do this in DEBUG mode only
SELECT VERSION()
Rows: 1 – Time: 0.0001s (0.20%)
Query #2: we do this in DEBUG mode only
SET sql_mode = "TRADITIONAL"
Rows: 0 – Time: 0.0001s (0.09%)
Query #3:
SELECT set_name, set_value
FROM evo_settings
Rows: 83 – Time: 0.0001s (0.18%)
Query #4: Loading plugin events
SELECT pevt_plug_ID, pevt_event
FROM evo_pluginevents
INNER JOIN evo_plugins ON pevt_plug_ID = plug_ID
WHERE pevt_enabled > 0
AND plug_status = 'enabled'
ORDER BY plug_priority, plug_classname
Rows: 0 – Time: 0.0001s (0.15%)
Query #5:
SELECT loc_locale, loc_charset, loc_datefmt, loc_timefmt, loc_startofweek,
loc_name, loc_messages, loc_priority, loc_transliteration_map, loc_enabled
FROM evo_locales
ORDER BY loc_priority
Rows: 1 – Time: 0.0001s (0.10%)
Query #6:
SET NAMES latin1
Rows: 0 – Time: 0.0001s (0.14%)
Query #7:
SELECT sess_ID, sess_key, sess_data, sess_user_ID, sess_start_ts, sess_lastseen_ts, sess_device
FROM evo_sessions
WHERE sess_ID = '24789014'
AND sess_key = 'lY3dA6n51roOCySnYa6kL4j2LhP6dV3T'
AND UNIX_TIMESTAMP(sess_lastseen_ts) > 1385160781
Rows: 1 – Time: 0.0004s (0.68%)
Query #8: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 1)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.15%)
Query #9: Loading Group(ALL) into cache
SELECT *
FROM evo_groups
ORDER BY grp_name
Rows: 6 – Time: 0.0001s (0.13%)
Query #10: BEGIN transaction
BEGIN
Rows: 0 – Time: 0.0001s (0.09%)
Query #11:
SELECT *
FROM evo_groups__groupsettings
WHERE gset_grp_ID = 1
Rows: 20 – Time: 0.0001s (0.10%)
Query #12: COMMIT transaction
COMMIT
Rows: 0 – Time: 0.0000s (0.08%)
Query #13:
SELECT gset_grp_ID, gset_name, gset_value
FROM evo_groups__groupsettings
WHERE gset_grp_ID = '1'
Rows: 20 – Time: 0.0001s (0.09%)
Query #14:
SELECT uset_user_ID, uset_name, uset_value
FROM evo_users__usersettings
WHERE uset_user_ID = '1'
Rows: 47 – Time: 0.0001s (0.10%)
Query #15: DataObjectCache::get_by_ID()
SELECT *
FROM evo_blogs
WHERE (blog_ID = 1)
ORDER BY blog_ID
Rows: 1 – Time: 0.0001s (0.12%)
Query #16:
SELECT cset_coll_ID, cset_name, cset_value
FROM evo_coll_settings
WHERE cset_coll_ID = '1'
Rows: 137 – Time: 0.0001s (0.16%)
Query #17: DataObjectCache::get_by_ID()
SELECT *
FROM evo_files
WHERE (file_ID = 14)
ORDER BY file_ID
Rows: 1 – Time: 0.0001s (0.12%)
Query #18: Loading Filetype(ALL) into cache
SELECT *
FROM evo_filetypes
ORDER BY ftyp_extensions
Rows: 20 – Time: 0.0001s (0.15%)
Query #19:
SELECT COUNT(*)
FROM evo_messaging__threadstatus ts
LEFT OUTER JOIN evo_messaging__message mu
ON ts.tsta_first_unread_msg_ID = mu.msg_ID
INNER JOIN evo_messaging__message mm
ON ts.tsta_thread_ID = mm.msg_thread_ID
AND mm.msg_datetime >= mu.msg_datetime
WHERE ts.tsta_first_unread_msg_ID IS NOT NULL
AND (ts.tsta_thread_leave_msg_ID IS NULL
OR ts.tsta_first_unread_msg_ID <= tsta_thread_leave_msg_ID)
AND (ts.tsta_user_ID = '1')
Rows: 1 – Time: 0.0001s (0.11%)
Query #20: Loading Blog(ALL) into cache
SELECT *
FROM evo_blogs
ORDER BY blog_ID ASC, blog_ID ASC
Rows: 1 – Time: 0.0001s (0.15%)
Query #21: Get CommentQuery Item IDs
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND ( ( ( post_status IN ( 'published','community','protected' ) ) ) )
Rows: 965 – Time: 0.0072s (12.32%)
Query #22: CommentList2::count_total_rows()
SELECT COUNT( comment_ID)
FROM evo_comments
LEFT JOIN evo_items__item_settings as expiry_setting ON iset_item_ID = comment_post_ID
AND iset_name = "post_expiry_delay"
WHERE ( ( ( comment_status IN ( 'review','draft' ) ) ) )
AND (comment_type IN ('comment','trackback','pingback'))
AND (comment_post_ID IN (33,34,55,65,68,80,81,93,104,124,141,156,178,184,218,225,251,253,259,267,305,366,447,488,496,508,556,587,591,604,639,659,663,665,667,690,697,702,713,726,739,741,744,745,753,780,786,809,822,825,848,849,... [Show more]
Rows: 1 – Time: 0.0039s (6.66%)
Query #23: CommentList2::Query() Step 1: Get ID list
SELECT comment_ID
FROM evo_comments
LEFT JOIN evo_items__item_settings as expiry_setting ON iset_item_ID = comment_post_ID
AND iset_name = "post_expiry_delay"
WHERE ( ( ( comment_status IN ( 'review','draft' ) ) ) )
AND (comment_type IN ('comment','trackback','pingback'))
AND (comment_post_ID IN (33,34,55,65,68,80,81,93,104,124,141,156,178,184,218,225,251,253,259,267,305,366,447,488,496,508,556,587,591,604,639,659,663,665,667,690,697,702,713,726,739,741,744,745,753,780,786,809,822,825,848,849,855,857,8... [Show more]
Rows: 0 – Time: 0.0039s (6.65%)
Query #24: CommentList2::Query() Step 2
SELECT *
FROM evo_comments
WHERE 0
Rows: 0 – Time: 0.0001s (0.11%)
Query #25: ItemList2::count_total_rows()
SELECT COUNT( DISTINCT post_ID)
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'community' ) ) ) )
Rows: 1 – Time: 0.0005s (0.78%)
Query #26: ItemList2::Query() Step 1: Get ID list
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'community' ) ) ) )
ORDER BY post_datemodified DESC, post_ID DESC
LIMIT 5
Rows: 0 – Time: 0.0005s (0.93%)
Query #27: ItemList2::Query() Step 2
SELECT *
FROM evo_items__item
WHERE 0
Rows: 0 – Time: 0.0001s (0.13%)
Query #28: ItemList2::count_total_rows()
SELECT COUNT( DISTINCT post_ID)
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'protected' ) ) ) )
Rows: 1 – Time: 0.0004s (0.64%)
Query #29: ItemList2::Query() Step 1: Get ID list
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'protected' ) ) ) )
ORDER BY post_datemodified DESC, post_ID DESC
LIMIT 5
Rows: 0 – Time: 0.0004s (0.61%)
Query #30: ItemList2::Query() Step 2
SELECT *
FROM evo_items__item
WHERE 0
Rows: 0 – Time: 0.0001s (0.11%)
Query #31: ItemList2::count_total_rows()
SELECT COUNT( DISTINCT post_ID)
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'review' ) ) ) )
Rows: 1 – Time: 0.0005s (0.85%)
Query #32: ItemList2::Query() Step 1: Get ID list
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'review' ) ) ) )
ORDER BY post_datemodified DESC, post_ID DESC
LIMIT 5
Rows: 1 – Time: 0.0006s (1.09%)
Query #33: ItemList2::Query() Step 2
SELECT *
FROM evo_items__item
WHERE post_ID IN (797)
ORDER BY post_datemodified DESC, post_ID DESC
Rows: 1 – Time: 0.0003s (0.55%)
Query #34: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 73)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.17%)
Query #35: Loading Chapter(ALL) into cache
SELECT *
FROM evo_categories
ORDER BY cat_name
Rows: 48 – Time: 0.0001s (0.18%)
Query #36: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '797'
ORDER BY postcat_cat_ID
Rows: 3 – Time: 0.0003s (0.53%)
Query #37: ItemList2::count_total_rows()
SELECT COUNT( DISTINCT post_ID)
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'draft' ) ) ) )
Rows: 1 – Time: 0.0005s (0.88%)
Query #38: ItemList2::Query() Step 1: Get ID list
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'draft' ) ) ) )
ORDER BY post_datemodified DESC, post_ID DESC
LIMIT 5
Rows: 0 – Time: 0.0005s (0.81%)
Query #39: ItemList2::Query() Step 2
SELECT *
FROM evo_items__item
WHERE 0
Rows: 0 – Time: 0.0001s (0.14%)
Query #40: ItemList2::count_total_rows()
SELECT COUNT( DISTINCT post_ID)
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'published','community','protected','private','review','draft','deprecated','redirected' ) ) ) )
Rows: 1 – Time: 0.0076s (13.07%)
Query #41: ItemList2::Query() Step 1: Get ID list
SELECT DISTINCT post_ID
FROM evo_items__item
INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( cat_blog_ID = 1 )
AND (( post_ptyp_ID IS NULL
OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000,4000) ))
AND ( ( ( post_status IN ( 'published','community','protected','private','review','draft','deprecated','redirected' ) ) ) )
ORDER BY post_datemodified DESC, post_ID DESC
LIMIT 5
Rows: 5 – Time: 0.0055s (9.34%)
Query #42: ItemList2::Query() Step 2
SELECT *
FROM evo_items__item
WHERE post_ID IN (1067,1066,1065,1064,1063)
ORDER BY post_datemodified DESC, post_ID DESC
Rows: 5 – Time: 0.0010s (1.69%)
Query #43: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 30)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.14%)
Query #44: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '1067'
ORDER BY postcat_cat_ID
Rows: 3 – Time: 0.0001s (0.11%)
Query #45: get_attachment_FileList
SELECT file_ID, file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, link_ID
FROM evo_links
INNER JOIN evo_files ON link_file_ID = file_ID
WHERE link_itm_ID = 1067
AND (link_position IN ( 'teaser' ))
ORDER BY link_order
LIMIT 1000
Rows: 0 – Time: 0.0001s (0.14%)
Query #46:
SELECT plug_ID, plug_priority, plug_classname, plug_code, plug_name, plug_shortdesc, plug_status, plug_version, plug_spam_weight
FROM evo_plugins
WHERE plug_status = 'enabled'
ORDER BY plug_priority, plug_classname
Rows: 0 – Time: 0.0001s (0.11%)
Query #47: Preload prerendered item content for MainList/ItemList (text)
SELECT itpr_itm_ID, itpr_format, itpr_renderers, itpr_content_prerendered
FROM evo_items__prerendering
WHERE itpr_itm_ID IN ('1067','1066','1065','1064','1063')
AND itpr_format = 'text'
Rows: 5 – Time: 0.0006s (1.10%)
Query #48: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 167)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.15%)
Query #49: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '1066'
ORDER BY postcat_cat_ID
Rows: 2 – Time: 0.0004s (0.62%)
Query #50: get_attachment_FileList
SELECT file_ID, file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, link_ID
FROM evo_links
INNER JOIN evo_files ON link_file_ID = file_ID
WHERE link_itm_ID = 1066
AND (link_position IN ( 'teaser' ))
ORDER BY link_order
LIMIT 1000
Rows: 0 – Time: 0.0001s (0.14%)
Query #51: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 117)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.15%)
Query #52: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '1065'
ORDER BY postcat_cat_ID
Rows: 3 – Time: 0.0003s (0.56%)
Query #53: get_attachment_FileList
SELECT file_ID, file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, link_ID
FROM evo_links
INNER JOIN evo_files ON link_file_ID = file_ID
WHERE link_itm_ID = 1065
AND (link_position IN ( 'teaser' ))
ORDER BY link_order
LIMIT 1000
Rows: 0 – Time: 0.0001s (0.13%)
Query #54: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 46)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.15%)
Query #55: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '1064'
ORDER BY postcat_cat_ID
Rows: 3 – Time: 0.0003s (0.51%)
Query #56: get_attachment_FileList
SELECT file_ID, file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, link_ID
FROM evo_links
INNER JOIN evo_files ON link_file_ID = file_ID
WHERE link_itm_ID = 1064
AND (link_position IN ( 'teaser' ))
ORDER BY link_order
LIMIT 1000
Rows: 0 – Time: 0.0001s (0.13%)
Query #57: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE (user_ID = 7)
ORDER BY user_ID
Rows: 1 – Time: 0.0001s (0.14%)
Query #58: Get category associations with given item
SELECT postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID = '1063'
ORDER BY postcat_cat_ID
Rows: 2 – Time: 0.0004s (0.63%)
Query #59: get_attachment_FileList
SELECT file_ID, file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, link_ID
FROM evo_links
INNER JOIN evo_files ON link_file_ID = file_ID
WHERE link_itm_ID = 1063
AND (link_position IN ( 'teaser' ))
ORDER BY link_order
LIMIT 1000
Rows: 0 – Time: 0.0001s (0.11%)
Query #60:
REPLACE INTO evo_settings (set_name, set_value)
VALUES ('evonet_last_attempt', '1385765581')
Rows: 2 – Time: 0.0146s (24.95%)
Query #61:
SELECT blog_ID
FROM evo_blogs
Rows: 1 – Time: 0.0001s (0.13%)
Query #62:
SELECT blog_ID
FROM evo_blogs
INNER JOIN evo_coll_settings ON
( blog_ID = cset_coll_ID
AND cset_name = "cache_enabled"
AND cset_value = "1" )
Rows: 1 – Time: 0.0001s (0.19%)
Query #63:
SET NAMES utf8
Rows: 0 – Time: 0.0001s (0.10%)
Query #64:
SELECT cach_name, cach_cache
FROM evo_global__cache
Rows: 8 – Time: 0.0003s (0.56%)
Query #65:
SELECT COUNT( * )
FROM evo_users
Rows: 1 – Time: 0.0003s (0.56%)
Query #66:
SELECT COUNT( * )
FROM evo_blogs
Rows: 1 – Time: 0.0001s (0.21%)
Query #67:
SELECT COUNT( * )
FROM evo_items__item
Rows: 1 – Time: 0.0003s (0.54%)
Query #68:
SELECT COUNT( * )
FROM evo_slug
Rows: 1 – Time: 0.0004s (0.76%)
Query #69:
SELECT COUNT( * )
FROM evo_comments
Rows: 1 – Time: 0.0002s (0.38%)
Query #70:
SELECT COUNT( * )
FROM evo_files
Rows: 1 – Time: 0.0002s (0.33%)
Query #71:
SELECT COUNT( * )
FROM evo_messaging__thread
Rows: 1 – Time: 0.0001s (0.16%)
Query #72:
SELECT COUNT( * )
FROM evo_messaging__message
Rows: 1 – Time: 0.0001s (0.20%)
Query #73: Session::dbsave()
UPDATE evo_sessions SET
sess_lastseen_ts = '2013-11-29 17:53:01',
sess_data = 'a:1:{s:19:\"crumb_latest_voting\";a:2:{i:0;N;i:1;s:43:\"s3QiPk9ayLfVK0IfUUCDnQIjr6VqI70j-1385765581\";}}',
sess_ipaddress = '184.78.138.54',
sess_key = 'lY3dA6n51roOCySnYa6kL4j2LhP6dV3T', sess_user_ID = 1
WHERE sess_ID = 24789014
Rows: 1 – Time: 0.0002s (0.38%)
Query #74:
REPLACE INTO evo_settings (set_name, set_value)
VALUES ('evonet_last_attempt', '1385765581')
Rows: 2 – Time: 0.0006s (1.06%)
Total rows: 1422
Measured time: 0.0585s
Profiled time: 0.0000s

5 Nov 30, 2013 03:04

Ok, the only thing left that looks like it may still be broken is the images in my posts aren't showing up; instead there is code like this - \"\"

6 Nov 30, 2013 21:32

Ok, I'm back once again. I fixed the images problem - well at least enough for now, going here on out I can at least add images to future articles. Now the problem I'm running into is unable to login. It appears to be exactly this problem that was reported before - http://forums.b2evolution.net/problem-upgrading-from-1-10. MySQL is reporting Latin1 instead of charset utf8. I've tried tweaking various PHP files as well as converting it over to all utf8 charsets in MySQL, but doing that gives me even more errors. From things I've read on other sites, it may because converting the charsets in MySQL is not as easy as just changing the designation.

I was fine under my login as long as I didn't log out of my browser - then one of the kids plugged the vacuum into an outlet that was overloaded and blew a fuse :-( Now I can't even login as myself as admin.

This is the error message that pops up when I try to login -

session:
Session: Session data corrupted!
connection_charset: 'latin1'
Serialized data was: --['a:2:{s:22:\\"crumb_latest_loginform\\";a:2:{i:0;N;i:1;s:43:\\"iwQH1YVTgz6GHAmYmohbMiqdTQSKjuSv-1385842992\\";}s:13:\\"core.pwd_salt\\";a:2:{i:0;i:1385929392;i:1;s:64:\\"AzIN6SW3zrTsX0rGBb6CgVI1D956xUM5l1rKgc5fgufQHlYI7OryZGAhxUq4R0Vg\\";}}']--

8 Dec 01, 2013 18:08

I tried it and here is the error message I get when I try to run the script ut8_upgrade.php (intellec_bvlt1 is the name of my database) -

Upgrading all tables in b2evolution MySQL database to UTF-8...

Notice: Undefined index: intellec_bvlt1 in /home/intellec/public_html/ut8_upgrade.php on line 7
An unexpected error has occurred!

If this error persists, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Incorrect database name ''(Errno=1102)

Your query:

SHOW TABLES

FROM `` LIKE "evo_%"

9 Dec 02, 2013 02:31

One more thing, after a lot more research, I realized I have this problem too - a different login url - http://forums.b2evolution.net/topic-18222

It goes back to my first gut instinct, that my hosting provider upgraded the server software. The site started giving me problems Sunday morning, so it made sense to me that the hosting provider scheduled an upgrade over night Saturday night....I have a message in to them but no response yet.

10 Dec 03, 2013 00:40

Ok, so the hosting provider said they didn't do any upgrades. They restored my site back to Nov. 8. No luck. Since the login url kept reverting to a url with htsrv in it, I tried tweaking some of the files to force it away from that. I changed the base url from my site's name to my site's name with index.php added on it inside _basic_config.php. It worked enough so that I could type in admin.php at the end of my site's base url and login successfully. However, there is some file that keeps trying to add "index.php" on the end, which makes the site look funny. If I could strip out that extra attempt to add index.php on there, my fix just might work. But I can't figure out what file is adding it on.

http://intellectualconservative.com/htsrv/login.php is the incorrect login path the site keeps jumping to


Form is loading...