Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12369
Latest: Dwaynee
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 40207
Total Topics: 7080
Most Online Today: 48
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 57
Total: 57

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

0 Members and 1 Guest are viewing this topic.

Offline Hatshepsut

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

+- Recent Topics

Font question by SMFHacks
May 27, 2020, 08:15:26 am

Error message with latest SMF 2.1 Github build by Hatshepsut
May 25, 2020, 01:43:26 am

smfblog not working on 2.0.17 by tech9
May 20, 2020, 01:44:34 pm

Copyright removal by stbc
May 18, 2020, 01:27:57 am

Mod Verified User i can't square the image by Rock Lee
May 07, 2020, 07:56:10 pm

SMF4Mobile 2.0 released for SMF 2.0.x by SMFHacks
May 06, 2020, 12:13:14 pm

SMF Social Login Pro - Discontinued? by Nicole
May 02, 2020, 05:47:04 pm

Likes by SMFHacks
April 30, 2020, 09:50:35 pm

Upgrade Issue - by SMFHacks
April 28, 2020, 12:40:13 pm

Issues regarding Licenses and Domain by SMFHacks
April 28, 2020, 10:59:41 am

Powered by EzPortal