Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4253
Latest: Ineedsmfhelp
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43242
Total Topics: 7516
Most Online Today: 126
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 126
Total: 126

Author Topic: SMF Gallery Pro Impor tIssues  (Read 18812 times)

0 Members and 1 Guest are viewing this topic.

Offline OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
SMF Gallery Pro Impor tIssues
« on: June 17, 2016, 03:45:46 am »
Hi there.

We recently purchased SMF Gallery pro for our forum (n gauge forum), you have logged in a few times and fixed some minor issues with the integration, however we still have the issue where the table in the db smf_messages has links to the old AEVA gallery system.  You sent us a script (aevafixposts) to run that should have replaced all the old "[SMD ID = xXXX]" code with links to the new gallery, but it fails when it runs, the counting part of the script works ok where it works its way through the posts but the database manipulation fails.  Could you contact myself of TANK to discuss how we move it forwards please.  I wonder if the script issues are the way it calls the database commands which is what seems to fail.

I think the problem stems from line 50 onwards maybe this command isnt running :- list($totalProcess) = mysql_Fetch_row($request);

Cheers Paul.
« Last Edit: June 17, 2016, 03:56:40 am by OnlyMe »

Offline OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #1 on: June 17, 2016, 06:45:37 am »
running it through php debug gives the following errors and I've listed the code at those lines from your php avea code:-

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in "SITENAME&PHPFILE"  on line 56
list($totalProcess) = mysql_Fetch_row($request);

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in "SITENAME&PHPFILE" on line 57
mysql_free_result($request);

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in "SITENAME&PHPFILE"  on line 72
while ($row = mysql_fetch_assoc($request))

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in "SITENAME&PHPFILE"  on line 110
mysql_free_result($request);

*"SITENAME&PHPFILE"  = is replacing the full site path etc when pasting to an open forum*

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #2 on: June 17, 2016, 07:59:54 am »
Try this file made a couple changes attached
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 OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #3 on: June 17, 2016, 09:22:05 am »
dont think I have the rights to download the file unfortunately :D

Offline tank_fv101

  • Community Suite Customer
  • Jr. Member
  • ******
  • Posts: 77
    • View Profile
    • N Gauge Forum
Re: SMF Gallery Pro Impor tIssues
« Reply #4 on: June 17, 2016, 10:34:12 am »
dont think I have the rights to download the file unfortunately :D

I have it mate.  I'll send it on FB.  Thanks SMFHacks!  Hopefully this will solve the issue for us.  :)

Offline OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #5 on: June 20, 2016, 03:58:32 am »
unfortunately it now fails at line 34, I put error reporting back in to see what causes it...

Notice: Undefined index: action in /www/sites/b83/37d/www.ngaugeforum.co.uk/web/SMFN/aveafixposts.php on line 34


mysql_select_db($db_name, $db_connection);
    $action = $_REQUEST['action'];                      <<---------------- LINE 34
    if (empty($action))
        $action = 'import2';

Please advise, also is there any way to be able to upload PDF documents to the gallery please?

Offline OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #6 on: June 20, 2016, 04:25:16 am »
the database doesn't like these calls you make in your script :-

mysql_free_result($request);


I think you need to login and test your code maybe as I havent written it its too difficult to debug especially now you canged the script from the one I debugged earlier.

Cheers Paul

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #7 on: June 20, 2016, 10:13:06 am »
I am not seeing any errors when I run.
Is there a specific post id it is not converting over?


Currently it only picks up posts with the exact bbcode [smg id = ###]


Quote
Please advise, also is there any way to be able to upload PDF documents to the gallery please?
There is no way to upload pdf documents. Only image,video/sound files are supported.

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 OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #8 on: June 20, 2016, 10:15:44 am »
it doesnt do any of them at all, the syntax in the db body is exactly this :-

[smg id=XXXXXX

no spaces..

I did try taking out the space from the search in your script but it bombed just the same.
I'll drop you a pm.
« Last Edit: June 20, 2016, 10:19:07 am by OnlyMe »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #9 on: June 21, 2016, 07:58:57 am »
Re ran the the post fix to pickup all post in [smg id=xxx] format and also found about 7,000 more pictures and added them to the gallery.


There are still about 7377 posts that have a different format than  [smg id=]
« Last Edit: June 21, 2016, 11:08:45 am by SMFHacks »
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 OnlyMe

  • Member
  • *
  • Posts: 9
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #10 on: June 22, 2016, 03:38:35 am »
hi there, when I looked at the DB, a lot of posts that may have had text in as well as pictures now seem to have been replaced with

[smg id=XXXXX type=box]

This worries me greatly as we were trying to move away from SMG ....

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: SMF Gallery Pro Impor tIssues
« Reply #11 on: June 22, 2016, 08:19:36 am »
I replied to your pm. type=box should be easy to replace.  I would do it on one test post first to check that it works ok.
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
4 Replies
7123 Views
Last post August 05, 2007, 06:38:33 am
by CdArtDisplay
1 Replies
5385 Views
Last post June 23, 2008, 07:10:29 pm
by SMFHacks
5 Replies
5095 Views
Last post February 17, 2011, 02:45:01 pm
by SMFHacks
1 Replies
4811 Views
Last post June 19, 2011, 07:04:57 pm
by SMFHacks
2 Replies
4553 Views
Last post May 20, 2012, 11:06:52 am
by CWVRV

+- Recent Topics

is it possible to add support for odysee.com by SMFHacks
March 13, 2024, 10:53:28 pm

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Powered by EzPortal