Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12399
Latest: SizofErsin
New This Month: 4
New This Week: 0
New Today: 0
Stats
Total Posts: 40606
Total Topics: 7132
Most Online Today: 142
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 92
Total: 92

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

0 Members and 1 Guest are viewing this topic.

Offline Hatshepsut

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 27
    • 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: 15290
    • 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
  • Newbie
  • *****
  • Posts: 27
    • 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: 15290
    • 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
1 Replies
3386 Views
Last post September 04, 2007, 06:59:49 pm
by rumboogy
1 Replies
4561 Views
Last post February 16, 2008, 11:53:55 am
by SMFHacks
9 Replies
3585 Views
Last post November 30, 2010, 09:19:56 pm
by SMFHacks
5 Replies
3557 Views
Last post August 26, 2013, 11:19:34 am
by SMFHacks
2 Replies
2037 Views
Last post February 06, 2019, 07:23:16 pm
by Oldiesmann

+- Recent Topics

Forum ToolBox by SMFHacks
Today at 10:34:06 am

Gallery Pro v8.0 and PHP 7.4 by SMFHacks
January 20, 2021, 10:21:25 pm

[Mod] Tagging System by SMFHacks
January 13, 2021, 08:43:33 pm

Using Alternate PayPal Address by KKOG
January 13, 2021, 07:24:46 pm

Assigning a BuyNow Button to a product by SMFHacks
January 12, 2021, 04:59:32 pm

SMF Links by Nicole
January 10, 2021, 12:02:39 pm

Error on the latest version by davejo
January 06, 2021, 08:04:05 am

Recent topics on board index by eugen
January 01, 2021, 11:08:16 am

Parser by swayforth
December 31, 2020, 12:24:23 am

Show Gallery in Users Profile by swayforth
December 29, 2020, 10:37:17 pm

Powered by EzPortal