vb.org Archive
Page 5 of 5 « First 34 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Ryangel's vB3 Journal -> vBJournal 1.0.0 Importer (https://vborg.vbsupport.ru/showthread.php?t=79005)

Cloud-Warrior 04-05-2005 04:23 PM
Yep the RSS export is somewhere in the original vBJournal thread, link from here:

http://www.johnbreslin.com/blog/2004...ournal-module/

Ghostsuit 04-18-2005 12:49 PM
Ok jsut done this on a test board and I'm having a little problem.

The main page for a users journal takes over a minute to load

Quote:
Page generated in 82.32792211 seconds (0.36% PHP - 99.64% MySQL) with 18 queries
Any idea what might be causing that?

Ghostsuit 04-18-2005 04:50 PM
Ok done a bit of digging and getting

Quote:
Query:

SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries AS journal_entries
LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id='3'
AND entry_active='1'
GROUP BY journal_entries.entry_id
ORDER BY entrydate ASC
LIMIT 0,10

Time before: 1.1279599666595
Time after: 15.869854927063
Time taken: 14.741894960403

table type possible_keys key key_len ref rows Extra
journal_entries ALL 16789 Using where; Using temporary; Using filesort
journal_comments ALL 13251
journal_moods eq_ref PRIMARY PRIMARY 4 journal_entries.mood 1
Should it really take that long for that process? I'm thinking not and I jsut found if I click one of the members with 900 entrys the time taken seems to be about 250 seconds at that point so I think somethign definitely up with that querie :S.

Ghostsuit 04-20-2005 12:13 AM
Paul M found the solution to my problem it's to do with Indexes on Journal we have over 16,000 entries so required indexes anyway this problem was nothing to do with the rygel transfer but a actual problem with the original Journal script. You can find my fix over in the journal thread around post 1095

Oblivion Knight 04-20-2005 05:56 AM
Thanks for the follow-up Ghostsuit.! :)

Kaelon 05-15-2005 12:30 AM
Quote:
Originally Posted by Ghostsuit
Paul M found the solution to my problem it's to do with Indexes on Journal we have over 16,000 entries so required indexes anyway this problem was nothing to do with the rygel transfer but a actual problem with the original Journal script. You can find my fix over in the journal thread around post 1095
And an excellent fix that they are. Added the three indexes, and performance has gotten so much better.

Kaelon 10-16-2005 03:31 AM
Is there any way we can use this script with an already up-and-running vB3.5 version of AN-Net's vBJournal?

Reeve of shinra 10-16-2005 04:28 AM
You probably could but just be careful since this script will drop any existing tables (so backup! backup! backup!).

edit:

If you already have a running journal on 3.5 and your looking to import these older journals...

- backup your current db
- restore it somewhere else
- do a table dump of the 3.5 joural tables
- rename those tables to get them out of the way for a few min
- run the converter to import the old journals
- dump those tables
- in excel or whatever the open office spreadsheet program is, copy the newly imported journals into the 3.5 journal tables you downloaded.
- fix the autoincrement ids
- save as csv and reimport that to your db.

Oblivion Knight 10-16-2005 06:35 AM
Quote:
Originally Posted by Kaelon
Is there any way we can use this script with an already up-and-running vB3.5 version of AN-Net's vBJournal?
Untested, unsupported and unlikely.. :speechless:


Quote:
Originally Posted by Reeve of shinra
You probably could but just be careful since this script will drop any existing tables (so backup! backup! backup!).
Eh? No it doesn't.. :p

kgirl 04-18-2006 03:08 PM
I've just tried running this, and got the following error

Quote:
Database error in vBulletin 3.0.6:

Invalid SQL:
INSERT INTO journals (journal_id, journalist_id, journaldate, journalviews, entrycount, active)
SELECT journalid, userid, timestamp, views, entries, enabled
FROM bjournal
ORDER BY userid ASC

mysql error: Duplicate entry '3' for key 1

mysql error number: 1062
Not being an expert, I've no idea what to do. I've searched here and couldn't find anything.

Can anyone help PLEASE!! :cry:


All times are GMT. The time now is 09:58 AM.
Page 5 of 5 « First 34 5
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01093 seconds
  • Memory Usage 1,741KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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