SMFHacks.com

Downloads System Pro => Support => Topic started by: Hatshepsut on April 11, 2020, 01:37:14 am

Title: Cannot import Tinyportal downloads
Post by: Hatshepsut on April 11, 2020, 01:37:14 am

Hello,

I am using Downloads System Pro version 5.0b on SMF 2.1RC2.
Installation was successful, but I cannot import Tinyportal downloads. I have Tinyportal 1.6.5 installed with more than 2,600 files in its download section.
When I click on 'Import' button, I get an error message:

Code: [Select]

Unknown column 'authorid' in 'field list'
File: /home/bulataka/public_html/BNF/Sources/Downloads2.php
Line: 9451
Forum details:

Version Information:
Forum version: SMF 2.1 RC2 (more detailed)
Current SMF version: SMF 2.1 RC2
GD version: bundled (2.1.0 compatible)
MySQLi engine: MariaDB
MySQLi version: 10.3.22-MariaDB-log
PHP: 7.3.16 (more detailed)
Server version: Apache

Title: Re: Cannot import Tinyportal downloads
Post by: SMFHacks on April 11, 2020, 05:57:05 am

5.0c
! Fixed bug with importing from newer versions of TinyPortal

Title: Re: Cannot import Tinyportal downloads
Post by: Hatshepsut on April 27, 2020, 12:53:00 pm

With new version, I get new error message:

Code: [Select]

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1535860293,1, 136, 56, 1585789498 )' at line 3
File: /home/bulataka/public_html/BNF/Sources/Downloads2.php
Line: 9492
I've started to move all Tinyportal downloads manually, one-by-one, and I found the reason for this error:

Some download item names and descriptions include Bulgarian letter ѝ (https://en.wikipedia.org/wiki/I_with_grave_(Cyrillic)), or old Bulgarian letters Ѣ (U+0462, U+0463) and Ѫ (U+0468, U+0469)
Tinyportal download manager recognizes these letters, but Download System cannot.

Title: Re: Cannot import Tinyportal downloads
Post by: SMFHacks on April 27, 2020, 01:32:25 pm

You would need to change the download tables to utf8 you can change collation via phpmyadmin