vb.org Archive
Page 7 of 11 « First 56 7 89 Last »
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)
-   -   Miscellaneous Hacks - ImpEx Module: Xenforo (https://vborg.vbsupport.ru/showthread.php?t=283111)

Brandon Sheley 08-25-2012 02:25 AM
Quote:
Originally Posted by iBaker (Post 2339224)
3. The Attachments path I just could not get right. I tried echoing the path and it showed the correct web address for the internal_data/attachments of the source web site but it failed on all attachments. I copied the source attachments folder to a folder in the target domain (i.e. vb site) and used the path /home/xxx/public_html/source_att/attachments/ and that worked for about 500 attachments out of 14,500


Ouch...
What did you do about the attachments, where you just testing things out?

iBaker 08-25-2012 02:39 AM
Yes I was just testing things out and couldn't get them imported so had to give up...very funny that you have just posted as about 2hrs ago I reinstalled vb and are going to make a concentrated effort to try and get things right so if anyone can help with the attachments then please, let us know what you did...also the other biggest worry is passwords, I will pay to be able for my users to keep their passwords

RedFlamePro 08-27-2012 02:20 PM
who can convert this mod to vbb 3.8x , please

iBaker 09-02-2012 12:54 AM
Ok, I have been working on this a fair bit and are overcoming many of the problems that it has, both within Impex and this mod.

I have been doing this on my local PC using xampps and once it is all going properly will try on a web server and then if all goes well I will post here the little things that I have had to do to make it work...for example Attachments should use database not file system as that will cause an error etc.

The final error that I have come up with is in the very last process of changing the in-line attachments (step 11).

The error I get is:
Code:
ImpEx Database error

mysql error: Invalid SQL:
            SELECT attachmentid
            FROM attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT , 1000
       

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1000' at line 5

mysql error number: 1064

Date: Saturday 01st 2012f September 2012 12:24:14 PM
Database: recflynew_forum
MySQL error:
This is the code in the php file that causes the error (011.php):
Code:
        // Get an array data
        $attachments = $Db_target->query("
            SELECT attachmentid
            FROM {$t_tb_prefix}attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT $start_at, $per_page
        ");
MySQL Error 1064 seems to fire up if the delimiter is incorrect...it also interesting that there seems to be no value inserted for $start_at

Can anyone help with this final error...thanks!

iBaker 09-03-2012 07:26 AM
I give up on this...after 2 days of solid work I can't get it to work...maybe some of you can that only have very small sites but for example if you have any more than 1,000 attachments it will fail...you don't get passwords or even the videos that XF allows you in posts and more.

The only option for me now, and others that are not happy with XF is to go to IPB...a real pity for vb

big dan 09-03-2012 04:35 PM
Ian,

For what it's worth I imported 400,000+ posts with something like 20k attachments with this module. The only thing I had to change was Ragtek's edit here: https://vborg.vbsupport.ru/showpost....4&postcount=55

Inline attachments stalled for me with no error given so I skipped it. It isn't a major step it just places the attachment code in posts.

iBaker 09-03-2012 11:11 PM
Quote:
Originally Posted by big dan (Post 2362281)
Ian,

For what it's worth I imported 400,000+ posts with something like 20k attachments with this module. The only thing I had to change was Ragtek's edit here: https://vborg.vbsupport.ru/showpost....4&postcount=55

Inline attachments stalled for me with no error given so I skipped it. It isn't a major step it just places the attachment code in posts.
So are you saying that any post that has an inline attachment will still show the attach code in the post and no image but the attached image will show as a standard attachment?

This would result in messy posts wouldn't it?

Also what did you do about Avatars as my attempts show the user's avatar ok when viewing the user in the ACP however their avatar doesn't display in any postbits?

Also XF has the ability to display YouTube, Vimeo etc videos inline in posts. How did you handle their display instead of just leaving the bbcode text of them again making posts look messy?

Also what process do you do after step 10 given that you didn't run step 11?

iBaker 09-04-2012 04:14 AM
Just completed another import in my test xampp environment on my PC and are resolving 3many of the little issues...eg, Avatars are now working etc.

A couple of big issues that I have found is that the importer doesn't seem to do is:
Poll information...it only imports the first option of a poll and not all the other options so all polls just have one entry
Profile Messages don't seem to import either
IP addresses of posts don't get imported

big dan 09-06-2012 04:42 PM
Quote:
Originally Posted by iBaker (Post 2362447)
Just completed another import in my test xampp environment on my PC and are resolving 3many of the little issues...eg, Avatars are now working etc.

A couple of big issues that I have found is that the importer doesn't seem to do is:
Poll information...it only imports the first option of a poll and not all the other options so all polls just have one entry
Profile Messages don't seem to import either
IP addresses of posts don't get imported
I noticed the lack of IP address and Profile messages after the import. Visitor messages are rarely used on my board and the IP address I can live without.

Quote:
Originally Posted by iBaker (Post 2362384)
So are you saying that any post that has an inline attachment will still show the attach code in the post and no image but the attached image will show as a standard attachment?

This would result in messy posts wouldn't it?

Also what did you do about Avatars as my attempts show the user's avatar ok when viewing the user in the ACP however their avatar doesn't display in any postbits?

Also XF has the ability to display YouTube, Vimeo etc videos inline in posts. How did you handle their display instead of just leaving the bbcode text of them again making posts look messy?

Also what process do you do after step 10 given that you didn't run step 11?
Yeah, I left the posts messy. I'll edit them as they come up but I'm not very worried about it.

After step 10 I clicked the database cleanup and restart link to delete the session then dumped the IMPEX files and ran all the counter updates.

Alien 09-07-2012 04:41 PM
I hope to see this updated for profile messages and thread prefixes.

Thanks, Andreas!


All times are GMT. The time now is 09:33 AM.
Page 7 of 11 « First 56 7 89 Last »
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.01125 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
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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