Recent Topics

1 Jul 29, 2007 22:38    

My b2evolution Version: 1.9.x

Moved to a new host who has 1.9.3 via fantastico. I was on on version 1.8.x.
imported the four years plus of blog data into the new database, not without headaches and, yes, I did delete some of the extra default blogs. Changed blog-ID so things matched, or so I thot. Got the the dreaded blog don't exist.

Can't figure out where I may have pooped it. It appears to be in a late query. below is the debug messages. Blog_ID is 2, there is not 3 (anymore) Where is dataobjects getting the 3 from? Help.

Backtrace:

1. debug_die( "Requested Blog does not exist!" )
File: /home/twifinei/public_html/witb/inc/MODEL/dataobjects/_dataobjectcache.class.php:346
2. DataObjectCache->get_by_ID( "3" )
File: /home/twifinei/public_html/witb/inc/MODEL/items/_item.class.php:746
3. Item->categories()
File: /home/twifinei/public_html/witb/skins/custom/_main.php:510
4. require( "/home/twifinei/public_html/witb/skins/custom/_main.php" )
File: /home/twifinei/public_html/witb/inc/_blog_main.inc.php:433
5. require( "/home/twifinei/public_html/witb/inc/_blog_main.inc.php" )
File: /home/twifinei/public_html/witb/index.php:106

Ignored last: 1

Debug info
Timers
Category Time % Count
total 0.117 100.00% 1
main.inc 0.092 78.63% 1
_blog_main.inc 0.014 11.97% 1
sql_queries 0.010 8.55% 15
skin/_main.inc 0.005 4.27% 1
abstractsettings_GeneralSettings_get 0.001 0.85% 16
plugin_init 0.000 0.00% 1
Hit::get_remote_host 0.000 0.00% 1
Database queries: 15.

Debug messages

dataobjects:

* Loading User(1) into cache
* Loading Blog(http://whatsinthebag.us/) into cache
* Loading Blog(3) into cache
* Could not get DataObject by ID. Query: SELECT * FROM T_blogs WHERE blog_ID = 3

detectblog:

* No blog param received, checking extra path...
* Looking up absolute url : http://whatsinthebag.us/
* Found matching blog: 2

hit:

* IP: 66.61.111.50
* UserAgent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5
* Referer: false; type=direct
* Remote Host:

locale:

* default_locale from conf: en-EU
* default_locale from DB: en-US
* default_locale from HTTP_ACCEPT: en-US
* $evo_charset follows $io_charset (iso-8859-1).
* Set DB connection charset: latin1
* evo_charset: iso-8859-1
* io_charset: iso-8859-1
* Activating blog locale: en-US

login:

* login: NULL
* pass: empty
* Was already logged in... [steveg]

memory:

* Len of serialized $cache_imgsize: 2
* Len of serialized $cache_File: 2

params:

* param(-): tempskin as string
* init $global_param_list
* memorize_param: tempskin string default=
* param(-): cookieb2evosession as string
* memorize_param: locale string default=
* param(-): login_action typed to array, new value=Array
* param(-): blog set to NULL
* memorize_param: blog integer default=
* param(-): blog typed to integer, new value=2
* memorize_param: blog integer default=0
* param(-): p set to NULL
* memorize_param: p integer default=
* param(-): title as string
* memorize_param: title string default=
* param(-): m set to NULL
* memorize_param: m integer default=
* param(-): w typed to integer, new value=-1
* memorize_param: w integer default=-1
* param(-): dstart set to NULL
* memorize_param: dstart integer default=
* param(-): unit as string
* memorize_param: unit string default=
* param(-): cat matched against /^[*\-]?([0-9]+(,[0-9]+)*)?$/
* memorize_param: cat string default=
* param(-): catsel typed to array, new value=Array
* memorize_param: catsel array default=Array
* param(-): author is empty: ok
* memorize_param: author string default=
* param(-): order as string
* memorize_param: order string default=DESC
* param(-): orderby as string
* memorize_param: orderby string default=
* param(-): posts typed to integer, new value=0
* memorize_param: posts integer default=0
* param(-): paged set to NULL
* memorize_param: paged integer default=
* param(-): poststart set to NULL
* memorize_param: poststart integer default=
* param(-): postend set to NULL
* memorize_param: postend integer default=
* param(-): s as string
* memorize_param: s string default=
* param(-): sentence as string
* memorize_param: sentence string default=AND
* param(-): exact set to NULL
* memorize_param: exact integer default=
* param(-): preview typed to integer, new value=0
* memorize_param: preview integer default=0
* param(-): calendar as string
* memorize_param: calendar string default=
* param(-): page set to NULL
* memorize_param: page integer default=
* param(-): more typed to integer, new value=0
* memorize_param: more integer default=0
* param(-): c as string
* memorize_param: c string default=
* param(-): tb typed to integer, new value=0
* memorize_param: tb integer default=0
* param(-): pb typed to integer, new value=0
* memorize_param: pb integer default=0
* param(-): disp as string
* memorize_param: disp string default=posts
* param(-): stats typed to integer, new value=0
* param(-): tempskin as string
* memorize_param: tempskin string default=
* blog_baseuri: "/"
* Extra path info found! path_string=
* param(-): results_page typed to integer, new value=1
* memorize_param: results_page integer default=1
* memorize_param: results_order string default=
* param(-): template as string
* memorize_param: template string default=main

perms:

* User perm blog_ismember:1:2 => granted

plugins:

* Loading plugin events.
* Trigger event SessionLoaded
* No registered plugins.
* Trigger event CachePageContent (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event CacheObjects (first true)
* No registered plugins.
* Trigger event AfterLoginRegisteredUser
* No registered plugins.
* Trigger event BeforeBlogDisplay
* No registered plugins.
* Trigger event GetProvidedSkins (first return)
* No registered plugins.
* Trigger event SkinBeginHtmlHead
* No registered plugins.

session:

* ID (from cookie): 710980
* ID is valid.
* user_ID: '1'
* No session data available.

settings:

* GeneralSettings::get( db_version// ): '9340'
* GeneralSettings::get( time_difference// ): '0'
* GeneralSettings::get( timeout_sessions// ): '604800'
* GeneralSettings::get( default_locale// ): 'en-US'
* GeneralSettings::get( posts_per_page// ): '10'
* GeneralSettings::get( what_to_show// ): 'posts'
* GeneralSettings::get( default_blog_ID// ): '2'
* GeneralSettings::get( default_blog_ID// ): '2'
* GeneralSettings::get( default_blog_ID// ): '2'
* GeneralSettings::get( default_blog_ID// ): '2'
* GeneralSettings::get( fm_enable_roots_blog// ): '1'
* GeneralSettings::get( permalink_type// ): 'urltitle'
* GeneralSettings::get( permalink_type// ): 'urltitle'
* GeneralSettings::get( default_blog_ID// ): '2'
* GeneralSettings::get( links_extrapath// ): '1'
* GeneralSettings::get( default_blog_ID// ): '2'

skin:

* No skin forced.
* $default_skin = custom
* Forced skin: custom

timer:

* Starting timer total
* Starting timer main.inc
* Starting timer abstractsettings_GeneralSettings_get
* Starting timer sql_queries
* Starting timer Hit::get_remote_host
* Starting timer plugin_init
* Starting timer _blog_main.inc
* Starting timer skin/_main.inc

vars:

* Getting ReqURI from REQUEST_URI
* $ReqHost: http://whatsinthebag.us
* $ReqURI: /
* $ReqPath: /

DB

DB queries: 15
Query #1:
SELECT set_name, set_value
FROM evo_settings
Rows: 49 – Time: 0.0001s (1.07%)
Query #2:
SELECT agnt_ID
FROM evo_useragents
WHERE agnt_signature = "Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5"
AND agnt_type = "browser"
Rows: 1 – Time: 0.0001s (0.56%)
Query #3:
SELECT sess_ID, sess_key, sess_data, sess_user_ID
FROM evo_sessions
WHERE sess_ID = '710980'
AND sess_key = 'aUeQCs8qcms77r0rPi9KWw2eHIiBy486'
AND UNIX_TIMESTAMP(sess_lastseen) > 1185132847
Rows: 1 – Time: 0.0003s (2.97%)
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: 10 – Time: 0.0001s (0.90%)
Query #5:
SELECT loc_locale, loc_charset, loc_datefmt, loc_timefmt, loc_startofweek, loc_name, loc_messages, loc_priority, loc_enabled
FROM evo_locales
ORDER BY loc_priority
Rows: 36 – Time: 0.0002s (1.64%)
Query #6: DataObjectCache::get_by_ID()
SELECT *
FROM evo_users
WHERE user_ID = 1
Rows: 1 – Time: 0.0001s (1.03%)
Query #7:
SET NAMES latin1
Rows: 0 – Time: 0.0001s (0.74%)
Query #8: Blog::get_by_url()
SELECT *
FROM evo_blogs
WHERE ( ( blog_siteurl REGEXP '^https?://'
AND ( 'http://whatsinthebag.us/' LIKE CONCAT( blog_siteurl, '%' )
OR 'https://whatsinthebag.us/' LIKE CONCAT( blog_siteurl, '%' ) ) ) )
Rows: 1 – Time: 0.0001s (1.10%)
Query #9:
SELECT *
FROM evo_blogusers
WHERE bloguser_blog_ID = 2
AND bloguser_user_ID = 1
Rows: 1 – Time: 0.0001s (1.01%)
Query #10: Get ID list for Item List (Main|Lastpostdate) Query
SELECT DISTINCT post_ID
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE (cat_blog_ID = 2)
AND ( ( ( post_status = "private"
AND post_creator_user_ID = 1 )
OR post_status IN ('published','protected') ) )
AND (post_datestart <= '2007-07-29 13:34:08')
ORDER BY post_datestart DESC
LIMIT 10
Rows: 10 – Time: 0.0040s (39.55%)
Query #11: Get data for Item List (Main|Lastpostdate) Query
SELECT *
FROM evo_posts
WHERE post_ID IN (1,2,387,386,385,384,383,382,381,380)
ORDER BY post_datestart DESC
Rows: 10 – Time: 0.0005s (4.51%)
Query #12: loading CAT cache
SELECT cat_ID, cat_parent_ID, cat_name, cat_blog_ID
FROM evo_categories
ORDER BY cat_name
Rows: 40 – Time: 0.0001s (0.95%)
Query #13: Get result count
SELECT COUNT( DISTINCT post_ID )
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE (cat_blog_ID = 2)
AND ( ( ( post_status = "private"
AND post_creator_user_ID = 1 )
OR post_status IN ('published','protected') ) )
AND (post_datestart <= '2007-07-29 13:34:08')
Rows: 1 – Time: 0.0038s (37.89%)
Query #14:
SELECT postcat_post_ID, postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID IN (380,381,382,383,384,385,386,387,2,1)
ORDER BY postcat_post_ID, postcat_cat_ID
Rows: 24 – Time: 0.0001s (0.90%)
Query #15: DataObjectCache::get_by_ID()
SELECT *
FROM evo_blogs
WHERE blog_ID = 3
Rows: 0 – Time: 0.0001s (0.98%)
Total rows: 185

2 Jul 30, 2007 05:14

Hmmm. Not sure, but I would have handled the move differently - like this:

(1) Make an empty DB first, at your new host and restore your existing 4-year b2evo blog DB into it, using myPhpAdmin.

(2) Then do the b2evo install, telling it that you already HAD a DB and to upgrade it.

This work-flow would eliminate the issue you're having.

3 Jul 30, 2007 14:09

stk,

I would have gone that route if it was available. Apparently the automated fantastico package removes the install, or I just couldn't find it.

Anyway, I found where the blog_ID=3 came from. It was from the dummy posts in the default pointing to categories. In the evo_category table there is a field called (I'm at work so I can't pull it up) cat_blog_id or something like that. Deleted or changed the records and I was good to go.

Thanks for responding.
This topic is solved.

4 Aug 01, 2007 06:58

baggeroh,

Glad you got it sorted and thanks for letting us know. I've marked your thread as "solved".

Cheers,
-stk


Form is loading...