Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12388
Latest: Rands
New This Month: 5
New This Week: 0
New Today: 0
Stats
Total Posts: 40308
Total Topics: 7099
Most Online Today: 142
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 33
Total: 33

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

0 Members and 1 Guest are viewing this topic.

Offline Hatshepsut

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

+- Recent Topics

Quality of images after import by SMFHacks
September 05, 2020, 10:21:44 am

How do I download gallery images? by CWVRV
August 30, 2020, 11:50:07 pm

Deleting Empty Galleries by SMFHacks
August 30, 2020, 11:43:32 am

PHP error by davejo
August 25, 2020, 07:35:13 am

Permissions to list ads and buy items by CWVRV
August 21, 2020, 05:19:45 pm

Doubt with download permissions. by Rock Lee
August 20, 2020, 08:23:24 pm

Attachment images Upsidedown or Sideways by SMFHacks
August 18, 2020, 05:41:07 pm

[Mod]Avatars Display Integration by Hatshepsut
August 17, 2020, 11:39:54 pm

Simple Portal Block - Classifieds by SMFHacks
August 16, 2020, 09:56:48 am

SMF Links by SMFHacks
August 16, 2020, 08:03:42 am

Powered by EzPortal