Advertisement:

Author Topic: [SMF Converter] PHP-Fusion 7  (Read 89276 times)

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #120 on: January 16, 2020, 09:06:37 AM »
Quote
We do not allow editing of posts after a few minutes on the forum.
Ah, thank you, so I was just too late :)

Quote
Can you run the query via mysql such as phpmyadmin
[...]

After the latest try, the error was:
Code: [Select]
Converting...
Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `tda_smf`.qpx_topics
    SET id_first_msg = '101154',
    id_member_started = '4973', id_last_msg = '101162',
    id_member_updated = '75', num_replies = '6'
    WHERE id_topic = 6982
    LIMIT 1;

Caused the error:

    1062

So I used the message above, phpmyadmin said:
Code: [Select]
SQL-Befehl:

UPDATE `tda_smf`.qpx_topics
SET id_first_msg = '101154',
id_member_started = '4973', id_last_msg = '101162',
id_member_updated = '75', num_replies = '6'
WHERE id_topic = 6982
LIMIT 1

MySQL meldet: Dokumentation
#1062 - Doppelter Eintrag '101154-6' für Schlüssel 'first_message'

What can I do? Between each try I cleared all database field that contained imported data, so this should not happen.

Do you also have an Idea regarding the attachment problem?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,954
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] PHP-Fusion 7
« Reply #121 on: January 16, 2020, 09:26:51 AM »
Try this convert.php for the second issue.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #122 on: January 16, 2020, 06:12:36 PM »
Looks like the last part worked, thank you!

Unfortunately there is still the problem with the attachments, could you help me with that, too? :)

I'm clueless, maybe the error message from #116 is the reason, i don't know :(

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #123 on: January 17, 2020, 03:42:00 PM »
I tried around, but there is always (depending on the SQL) file a message:

First, with "official" SQL file (Downloads > Converters > PHP Fusion 7) and convert.php from @vbgamer45:

Quote
Converting attachments...The database value you're trying to insert does not exist: id_attach
and the process stops (~500 files in attachments folder, no database entry for attachments).

PHP error log:
Code: [Select]
:07:05.994735 2020] [proxy_fcgi:error] [pid 32312:tid 140479656032000] [client *IP*:51774] AH01071: Got error 'PHP message: PHP Notice:  Undefined index: convert_script in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 987PHP message: PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 990
PHP message: PHP Notice:  Undefined index: convert_script in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1002', referer: https://PAGENAME/smf/convert.php
[Fri Jan 17 20:07:05.995076 2020] [proxy_fcgi:error] [pid 32312:tid 140479656032000] [client *IP*:51774] AH01071: Got error 'PHP message: PHP Deprecated:  strpos(): Non-string needles will be interpreted as strings in the future. Use an explicit chr() call to preserve the current behavior in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2449
PHP message: PHP Notice:  Undefined variable: result in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2510PHP message: PHP Notice:  Undefined variable: result in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 2511
PHP message: PHP Notice:  Undefined index: db_fetch_assoc in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1401
PHP message: PHP Fatal error:  Uncaught Error: Function name must be a string in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php:1401\nStack trace:\n#0 /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1341): doStep2()\n#1 /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(51): doStep1()\n#2 {main}\n  thrown in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php on line 1401', referer: https://PAGENAME/smf/convert.php
[b]PHP message: PHP Warning:  A non-numeric value encountered in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1269) : eval()'d code on line 4[/b]*
Last (bold marked) line appears more than 4400 times in the logfile (quick word search for "non-numeric value encountered"  8) )


Next try with Github SQL-file and convert.php from @vbgamer45:
Quote
Converting...
Converting attachments...
Successful.
Converting membergroups... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
So it seems to be finished  ( There are 10 005 files in attachments folder, (seems to be okay) but (this time) 11 database entries for attachments).

Code: [Select]
[Fri Jan 17 21:27:19.490425 2020] [proxy_fcgi:error] [pid 32312:tid 140479882856192] [client *IP*:60438] AH01071: Got error 'PHP message: PHP Warning:  A non-numeric value encountered in /var/www/vhosts/PAGENAME/httpdocs/smf/convert.php(1269) : eval()'d code on line 4This line also appears more than 4400 times in the logfile (quick word search for "non-numeric value encountered"  8) ) seems to be the same issue than above.

I tried also the official convert.php and the Github one, the result depends on the SQL-file (see above).

Regarding the PHP Fusion database, there should be around 10000 attachments.

So can someone help? Do you need further information?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,954
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] PHP-Fusion 7
« Reply #124 on: January 17, 2020, 04:49:16 PM »
Can you explain PHP fusion more I haven't used it before. Is it just a downloads system or does it do more with posts?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #125 on: January 17, 2020, 05:29:34 PM »
PHP Fusion is a CMS-system with integrated forum. The attachments are related to forum posts, mostly they are pictures in my case.


Downloads are not included with this converter, but i dont need it also. Just the forum contents including the post attachments would be fine.

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #126 on: January 20, 2020, 04:06:27 AM »
Do you need further information? :)

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #127 on: January 22, 2020, 04:18:12 AM »
Isn't there somebody out there who can help me?  :)
I'd spend a coffee or two for some help  ;D

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #128 on: January 24, 2020, 07:23:08 AM »
Can I do something to make it easier to help me? Id does not have to be for free of course, i just need to convert attachments, too :/

Offline szoller

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] PHP-Fusion 7
« Reply #129 on: February 12, 2020, 08:09:36 AM »
So, no way to help me? As you notice, i'm quite desparate

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,954
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [SMF Converter] PHP-Fusion 7
« Reply #130 on: February 13, 2020, 11:37:04 AM »
It would probably have to be done via a script that is manually created. Would take probably 2 to 3 hours of work depending on the format.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro