vb.org Archive - Administrative and Maintenance Tools

Page 75 of 85

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Import External Images (https://vborg.vbsupport.ru/showthread.php?t=253309)

RichieBoy67

03-09-2017 12:28 AM

Just found this in my log:

Database error in vBulletin 4.2.5 Beta 1:

Invalid SQL:
INSERT INTO oasl_session SET userid='85961', session_token='JEOGPb3rGt1nfI7PfB2LXGTq8B6xJazzQGD v', date_created='1488993068';

MySQL Error : Duplicate entry '85961' for key 'userid'
Error Number : 1062
Request Date : Wednesday, March 8th 2017 @ 12:11:07 PM
Error Date : Wednesday, March 8th 2017 @ 12:11:08 PM
Script : http://##############
Referrer : http://#######
IP Address : 173.245.50.139
Username : #######
Classname : vB_Database_MySQLi
MySQL Version :
Server : ########

It is supposed to be https://// also not sure about the duplicate session..

djbaxter

03-09-2017 06:50 AM

@RichieBoy67: That's essentially what is / was happening for me.

I recently updated to vBulletin 4.2.4 but I was getting all that with 4.2.3 PL2.

y2ksw

03-09-2017 08:03 AM

Quote:

Originally Posted by djbaxter (Post 2583462)

How do you mark it as "scanned ok"? How do you even know which image to do that for if there's no notification and if the add-on is no longer logging its activity?

The posts are scanned top-down (from postid=1 to latest).

The plugin adds a field to post, called iei_parsed.

If you issue the query:

Code:

SELECT postid 

FROM post 

WHERE iei_parsed>0 

ORDER BY postid DESC

LIMIT 1

you get the last post ID which was successfully parsed. If this value stays put, then something is not working.

As for the concerns with https and SSL (I've been looking into it now), requesting data from such sites requires you to use CURL. You can choose the mode from the options. CURL is installed anyway since required by 4.x vBulletin versions.

Marking a post "OK" can be done this way:

Code:

UPDATE post SET

iei_parsed=1

WHERE postid=N

where N is the postid.

y2ksw

03-09-2017 08:05 AM

Quote:

Originally Posted by RichieBoy67 (Post 2583502)

These are crashed database issues and require a table repair.

y2ksw

03-09-2017 08:07 AM

Quote:

Originally Posted by RichieBoy67 (Post 2583499)

I just checked and this does not appear to be working at all any more.. no changes to the settings or plug in but updated Vbulletin, changed php version..things like that. Vbulletin 4.2.4 beta 1..also changed site to https://

Cron tasks says done but nothing happens..

Please disregard my PM and see here:

https://vborg.vbsupport.ru/showpost....&postcount=743

djbaxter

03-09-2017 08:36 AM

Quote:

Originally Posted by y2ksw (Post 2583517)

The posts are scanned top-down (from postid=1 to latest).

The plugin adds a field to post, called iei_parsed.

If you issue the query:

Code:

SELECT postid 

FROM post 

WHERE iei_parsed>0 

ORDER BY postid DESC

LIMIT 1

Code:

UPDATE post SET

iei_parsed=1

WHERE postid=N

where N is the postid.

Thank you.

Running the first query shows 242442 as the last post ID.

Manually running the cron job leaves that number unchanged.

Running the second query yields

Code:

Affected Rows: 0 (0.0015s)

Repeating the whole sequence gives the same result.

Does that mean the add-on has stopped working?

Note my statement above that I recently updated to 4.2.4 but the issues were happening prior to that update.

RichieBoy67

03-09-2017 10:52 AM

1 Attachment(s)

Quote:

Originally Posted by y2ksw (Post 2583517)

The posts are scanned top-down (from postid=1 to latest).

The plugin adds a field to post, called iei_parsed.

If you issue the query:

Code:

SELECT postid 

FROM post 

WHERE iei_parsed>0 

ORDER BY postid DESC

LIMIT 1

Code:

UPDATE post SET

iei_parsed=1

WHERE postid=N

where N is the postid.

When I run this I get nothing..

##I get an id now after running a table repair. :) I will run the other one ..

RichieBoy67

03-09-2017 11:17 AM

I think it's working now because I do see the id moving after I run the 1st query. I do not see any new images yet in my import folder but I assume that just means it has not found any to import yet?

Thanks for your help!

djbaxter

03-09-2017 03:46 PM

Still not working for me. I did a repair and optimize on the database. No errors found.

RichieBoy67

03-09-2017 10:54 PM

Nope, not working.. looks like it went through the posts and is caught up with the last post but it has not imported any of the images..

All times are GMT. The time now is 05:22 AM.

Page 75 of 85

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02183 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: