Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4220
Latest: agolac
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 42854
Total Topics: 7464
Most Online Today: 112
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 44
Total: 44

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

0 Members and 2 Guests 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: 16257
    • 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: 16257
    • 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: 16257
    • 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
14339 Views
Last post November 10, 2010, 01:41:44 pm
by SMFHacks
38 Replies
27406 Views
Last post April 09, 2010, 08:27:43 pm
by bluedevil
26 Replies
12689 Views
Last post April 18, 2016, 08:48:58 am
by Asio Otus
5 Replies
4865 Views
Last post June 03, 2016, 06:45:29 am
by tank_fv101
3 Replies
2478 Views
Last post February 20, 2017, 05:46:07 pm
by SMFHacks

+- Recent Topics

Is the PayPal Sandbox still working? by Nicole
Today at 06:51:18 am

Question on Completed Listing & Reserve Price by Nicole
June 01, 2023, 06:06:12 pm

[Mod]GDPR Helper by Nicole
May 29, 2023, 11:58:49 pm

RSS Feed Poster Database Error by SMFHacks
May 22, 2023, 06:26:18 pm

Errors With Older Version. by Ken.
May 09, 2023, 05:35:40 pm

Pretty Urls SEO Pro by SMFHacks
May 06, 2023, 03:30:11 pm

New Post Image Upload Error by Mike66
April 28, 2023, 07:30:28 am

Copyright Removal Key by SMFHacks
April 03, 2023, 02:44:28 pm

Converting from Aeva Media by sudhakar
April 02, 2023, 11:09:54 am

Using SMF's Built-in Search Algorithm by shuban
March 27, 2023, 09:15:10 am

Powered by EzPortal