Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11805
Latest: DebT
New This Month: 1
New This Week: 1
New Today: 1
Stats
Total Posts: 41608
Total Topics: 7274
Most Online Today: 65
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 28
Total: 28

Author Topic: Cannot import Tinyportal downloads  (Read 7758 times)

0 Members and 1 Guest are viewing this topic.

Offline Hatshepsut

  • SMF Gallery Pro Customer
  • Member
  • *****
  • Posts: 38
    • View Profile
    • Bulgarian Nationalist Forum
Cannot import Tinyportal downloads
« 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

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15753
    • View Profile
Re: Cannot import Tinyportal downloads
« Reply #1 on: April 11, 2020, 05:57:05 am »
5.0c
! Fixed bug with importing from newer versions of TinyPortal
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Hatshepsut

  • SMF Gallery Pro Customer
  • Member
  • *****
  • Posts: 38
    • View Profile
    • Bulgarian Nationalist Forum
Re: Cannot import Tinyportal downloads
« Reply #2 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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15753
    • View Profile
Re: Cannot import Tinyportal downloads
« Reply #3 on: April 27, 2020, 01:32:25 pm »
You would need to change the download tables to utf8 you can change collation via phpmyadmin
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
11 Replies
14471 Views
Last post March 19, 2009, 05:21:59 pm
by Marian
1 Replies
3539 Views
Last post September 04, 2007, 06:59:49 pm
by rumboogy
1 Replies
4687 Views
Last post February 16, 2008, 11:53:55 am
by SMFHacks
9 Replies
3823 Views
Last post November 30, 2010, 09:19:56 pm
by SMFHacks
1 Replies
606 Views
Last post September 26, 2021, 05:48:03 pm
by SMFHacks

+- Recent Topics

Thanks mod SMF 2.1 by Monocero
November 27, 2021, 01:13:01 pm

How to change the font on a photo in SMF Gallery Pro? by SMFHacks
November 18, 2021, 09:28:11 am

Bulk Upload Many Pictures - File Name by SMFHacks
November 17, 2021, 08:58:50 am

Schedule or direct download link by SMFHacks
November 16, 2021, 10:57:33 am

Download Expire by Vincent Volmer
November 16, 2021, 02:40:47 am

prettyurls - TroubleShooting.wiki by SMFHacks
November 14, 2021, 02:18:59 pm

Error With Delete Download by mickjav
November 10, 2021, 04:49:12 pm

No ads on left or right by coyote
November 08, 2021, 04:57:13 pm

Now accepting Cryptocurrency by SMFHacks
November 05, 2021, 05:33:27 pm

Latest Version Pretty Urls SEO Pro by SMFHacks
November 04, 2021, 03:46:53 pm

Powered by EzPortal