Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4239
Latest: 3dickulus
New This Month: 4
New This Week: 1
New Today: 0
Stats
Total Posts: 43126
Total Topics: 7500
Most Online Today: 83
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 40
Total: 41

Author Topic: Converting from Aeva Media  (Read 2620 times)

0 Members and 1 Guest are viewing this topic.

Offline ivanr

  • Member
  • *
  • Posts: 3
    • View Profile
Converting from Aeva Media
« on: January 22, 2023, 04:31:06 pm »
I am trying to convert from Aeva media into SMF Gallery lite using the convertor tool but I am getting this error message.
Duplicate entry '15' for key 'PRIMARY'
File: /homepages/17/xxxxxxxxx/htdocs/xxxxxxx/public_html/forum/Sources/Subs-ConvertAeva2.php
Line: 1318

Where and how can I find the PRIMARY key to delete it and try again.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Converting from Aeva Media
« Reply #1 on: January 22, 2023, 04:49:04 pm »
The built in convertor in SMF Gallery Lite?
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 ivanr

  • Member
  • *
  • Posts: 3
    • View Profile
Re: Converting from Aeva Media
« Reply #2 on: January 23, 2023, 12:31:24 am »
Yes, using the built in converter.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Converting from Aeva Media
« Reply #3 on: January 24, 2023, 02:02:32 pm »
Can you attach your Subs-ConvertAeva2.php seems like the line number is different than the file I have.
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 ivanr

  • Member
  • *
  • Posts: 3
    • View Profile
Re: Converting from Aeva Media
« Reply #4 on: January 28, 2023, 10:09:42 am »
Well I managed to do it by just selecting fewer (the most important) albums to transfer across and therefore avoiding the album with the duplicate primary key.

Offline sudhakar

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Converting from Aeva Media
« Reply #5 on: April 02, 2023, 10:44:32 am »
Installing SMF gallery lite in my upgraded 2.1.3
And while trying to convert from aeva media, got this error.

Database Error
Incorrect integer value: '' for column 'totalratings' at row 1
File: /home/forum/public_html/Sources/Subs-ConvertAeva2.php
Line: 707

Guide me to any old post for resolution if any.

Admin Error log - line 707

Offline sudhakar

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Converting from Aeva Media
« Reply #6 on: April 02, 2023, 10:46:10 am »
Code: [Select]
Database Error: Incorrect integer value: '' for column 'totalratings' at row 1

INSERT INTO smf_gallery_pic
(id_picture,title,description,id_member,id_cat,
views, filesize, height, width,
filename, thumbfilename, mediumfilename,totalratings,rating,
commenttotal, approved, date, keywords,allowcomments )
VALUES ('1','Mega JOB FAIR - 19th and 20th',
'Companies - HP, Unisys & More

Walkin Date Jan 19, 20, Bangalore', '1164', '1', '728',
'347277', '1478', '943',
'albums/JOB_Album/Dir_1/main_1.png', 'albums/JOB_Album/Dir_1/thumb_1.png','albums/JOB_Album/Dir_1/medium_1.png','','',
'0',
'1','1200572255'
, 'hp, walk in, unisys, jobfair, hello, bpo, it, ites',1)

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Converting from Aeva Media
« Reply #7 on: April 02, 2023, 11:02:11 am »
I replied to you on the SMF site for the fix.
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 sudhakar

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Converting from Aeva Media
« Reply #8 on: April 02, 2023, 11:09:54 am »
I replied to you on the SMF site for the fix.

Checking, thank you

 

Related Topics

  Subject / Started by Replies Last post
15 Replies
14760 Views
Last post November 10, 2010, 01:41:44 pm
by SMFHacks
38 Replies
28339 Views
Last post April 09, 2010, 08:27:43 pm
by bluedevil
26 Replies
13184 Views
Last post April 18, 2016, 08:48:58 am
by Asio Otus
5 Replies
5195 Views
Last post June 03, 2016, 06:45:29 am
by tank_fv101
3 Replies
2754 Views
Last post February 20, 2017, 05:46:07 pm
by SMFHacks

+- Recent Topics

“Insert from Gallery” by apothocary
November 21, 2023, 07:25:28 am

SMFHacks Black Friday Sale 2023! by SMFHacks
November 19, 2023, 12:05:51 pm

File Count by SMFHacks
November 11, 2023, 11:46:46 am

Theme Changer by SMFHacks
November 09, 2023, 04:30:05 pm

Pretty Urls extras by SMFHacks
November 08, 2023, 05:23:14 pm

Member group access to emojis by SMFHacks
October 22, 2023, 07:24:12 am

Miscellaneous errors - don't know why by SMFHacks
October 13, 2023, 09:28:50 am

Follow / Follower Mod? by Nicole
October 06, 2023, 07:37:20 am

Mods supporting custom themes? by SMFHacks
October 02, 2023, 04:20:18 pm

Version 6.1.6 issues by SMFHacks
September 30, 2023, 07:54:52 am

Powered by EzPortal