Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 180
Total: 180

Author Topic: Rebuilding related index, You have an error in your SQL syntax  (Read 4621 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: 16436
    • 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: 16436
    • 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: 16436
    • 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: 16436
    • 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
32099 Views
Last post September 02, 2008, 08:06:08 pm
by SMFHacks
2 Replies
7914 Views
Last post January 24, 2009, 09:28:41 am
by cepsi
1 Replies
4032 Views
Last post April 02, 2009, 09:06:46 pm
by SMFHacks
6 Replies
7926 Views
Last post June 02, 2010, 01:23:16 am
by Tom
16 Replies
20053 Views
Last post October 03, 2017, 08:49:37 pm
by drewactual

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

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

Powered by EzPortal