SMFHacks.com

SMF Gallery Lite => SMF Gallery Lite => Topic started by: ivanr on January 22, 2023, 04:31:06 pm

Title: Converting from Aeva Media
Post by: ivanr 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.

Title: Re: Converting from Aeva Media
Post by: SMFHacks on January 22, 2023, 04:49:04 pm

The built in convertor in SMF Gallery Lite?

Title: Re: Converting from Aeva Media
Post by: ivanr on January 23, 2023, 12:31:24 am

Yes, using the built in converter.

Title: Re: Converting from Aeva Media
Post by: SMFHacks 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.

Title: Re: Converting from Aeva Media
Post by: ivanr 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.

Title: Re: Converting from Aeva Media
Post by: sudhakar 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

Title: Re: Converting from Aeva Media
Post by: sudhakar 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)

Title: Re: Converting from Aeva Media
Post by: SMFHacks on April 02, 2023, 11:02:11 am

I replied to you on the SMF site for the fix.

Title: Re: Converting from Aeva Media
Post by: sudhakar on April 02, 2023, 11:09:54 am

Quote from: SMFHacks on April 02, 2023, 11:02:11 am

I replied to you on the SMF site for the fix.

Checking, thank you