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: 88
Total: 88

Author Topic: Rebuilding related index, You have an error in your SQL syntax  (Read 4609 times)

0 Members and 1 Guest are viewing this topic.

Offline Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Rebuilding related index, You have an error in your SQL syntax
« on: February 25, 2018, 06:21:38 pm »
Tried to rebuild the related index and 54% though rebuilding it stopped and came up with this error,

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's+Pouting.jpg')' at line 3
File: /home2/scoobie/public_html/Sources/Gallery2.php
Line: 13194

I re-ran the rebuild with the same results. Now when I browse to the member galleries, there are no pictures for all users. Can I recover a table in the DB to rectify?

Running, SMF 2.0.15 with Gallery version, 7.2.2

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #1 on: February 25, 2018, 07:44:17 pm »
The smf_pictures table.

I will check out the related index rebuild issue. That's shouldn't break pictures though that just adds related images on the bottom of the view picture page.
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 SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #2 on: February 25, 2018, 08:14:38 pm »
Posted an update for that issue
8.0.1
!Fixed bug with rebuilding related index with 's characters in the title
https://www.smfhacks.com/index.php/topic,9539.0.html
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 Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #3 on: March 17, 2018, 12:29:55 pm »
I could not find an smf_pictures table so I tried to restore the following,

smf_gallery_pic

smf_gallery_related_pictures

No Joy... :(

Is there another table that I'm missing?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #4 on: March 17, 2018, 05:31:15 pm »
What error are you getting? Did you try the latest update?

Those should be the only tables.
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 Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #5 on: March 17, 2018, 06:08:21 pm »
Here's the error, All pictures for all member galleries are inaccessible. When you go to the Member Gallery page, all the members are listed but the pictures each have are listed as 0 on the member gallery page. You suggested I replace smf_pictures table with a backup but I don't have an smf_pictures table in the entire database so I tried replacing the smf_gallery_pic and then after that did now work, I tried the smf_gallery_related_pictures table. In between each try I replace the original table to verify I was back with the issue I was trying to fix. I have not tried the updated version you released because I did not want to loose the member gallery data...  ? Was trying to get back before I re-indexed so I could upgrade to the latest version.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: Rebuilding related index, You have an error in your SQL syntax
« Reply #6 on: March 17, 2018, 06:31:07 pm »
Well I would backup your database. Then upgrade. That will fix that sql error issue. I am still unsure what makes the pictures disappear though that is trange.

The smf_gallery_pic table stores all the pictures.

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
32097 Views
Last post September 02, 2008, 08:06:08 pm
by SMFHacks
2 Replies
7910 Views
Last post January 24, 2009, 09:28:41 am
by cepsi
1 Replies
4018 Views
Last post April 02, 2009, 09:06:46 pm
by SMFHacks
6 Replies
7914 Views
Last post June 02, 2010, 01:23:16 am
by Tom
16 Replies
20042 Views
Last post October 03, 2017, 08:49:37 pm
by drewactual

+- 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