Support Forums

Support Online : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

SP String Component

Featured Lock Resolved Bug
This is so far the bug when I installed the SP String Component extension.
1. The Artist and Event DB structure are not installed

1146 Table 'db667557937.#__spstrings_artists' doesn't exist SQL=SHOW FULL COLUMNS FROM `#__spstrings_artists`

1146 Table 'db667557937.#__spstrings_events' doesn't exist SQL=SHOW FULL COLUMNS FROM `#__spstrings_events`

2. At the Album option, it does not save the "Production By" and "Released Date" data
3. At the Event Option, cannot change "68-49-68-51 Main St, Flushing, NY 11367, USA" address from the Event Map.

4. From the SP Page Builder when I tried to publish the Audio Row, I get an error from the frontpage maybe because the "Production By" and "Released Date" data are not saving.

18 Answers

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Please check your google api key.

- Thanks

Gerry Go

More than a month ago #Permalink
Here is the error when I enable the Audio section from the Pagebuilder

UNKNOWN COLUMN 'A.RELEASE_DATE' IN 'FIELD LIST' SQL=SELECT `A`.`SPSTRINGS_ALBUM_ID`,`A`.`TITLE`,`A`.`SLUG`,`A`.`IMAGE`,`A`.`RELEASE_DATE`,`A`.`PRODUCTION_BY` FROM `#__SPSTRINGS_ALBUMS` AS `A` WHERE `ENABLED` = 1 AND `A`.`RELEASE_DATE` <= '2017-03-04' ORDER BY `A`.`RELEASE_DATE` DESC LIMIT 3

Gerry Go

More than a month ago #Permalink
Solved #4 or the error above was because the DB structure was not complete so I then again delete the Album DB and copied the one from my test site which is running the string quickstart version

Paul Frankowski - Staff

More than a month ago #Permalink
Gerry if you want to get answer from support do not add 2nd post before our respond, please.
---
we will check it and fix.
I redirected case to our dev team.

Gerry Go

More than a month ago #Permalink
I am trying to solve the bufs or issues that I discover if I can managed to resolve it while waiting for the updated String Component and Template

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Please follow this steps
> Uninstall strings component.
> Drop data base table #__spstrings_albums from mysql.
> Install again strings component from here


- Thanks

Gerry Go

More than a month ago #Permalink
Hi, I did the steps but the event map, I still cant replace the "68-49-68-51 Main St, Flushing, NY 11367, USA" address....

The Zoom from gmap.js still on 2...

Attachments (1)

  • eventmap.png
    eventmap.png 119.5 KB

Rifat Wahid Alif - Staff

More than a month ago #Permalink
could you please pm me your admin and mysql/cPanel access?

- Thanks

Gerry Go

More than a month ago #Permalink
Hi,

I have attached what I think you want to see. Even on the quickstart version, I cant update the event map.

Attachments (4)

  • events.png
    events.png 94.3 KB
  • artists.png
    artists.png 82.5 KB
  • album.png
    album.png 67.7 KB
  • joomla.png
    joomla.png 41.4 KB

Rifat Wahid Alif - Staff

More than a month ago #Permalink
database is correct it should work, now i need to check from joomla admin.

- Thanks

Gerry Go

More than a month ago #Permalink
database is correct it should work, now i need to check from joomla admin.

- Thanks


Anything specific you wanted to know within Joomla?

I installed String Quickstart but even that had the same issue that I cannot change the event map address. The only way I can do it is change it directly on the database which is not ideal.

Rifat Wahid Alif - Staff

More than a month ago #Permalink
in quick start pack its for me. i just downloaded quickstart pack and check it. so, if you can't give me admin access maube i can't give you any solutions. because i can't see anything here without checking your site.


- Thanks

Gerry Go

More than a month ago #Permalink
I have PM you privately

Gerry Go

More than a month ago #Permalink
That did the trick. Only question now is where is the Map pointer?

Rifat Wahid Alif - Staff

More than a month ago #Permalink
I think its already had pointer in frontend and backend.

- Thanks

Gerry Go

More than a month ago #Permalink
The map pointer does show on my test site but not on my production site which the only difference was the test site was straight from the quickstart and my prod site is individually installed String template & String Component.

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Could you please pm me your admin access for my closer look?

- Thanks


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Leaderboard (30 days)

Sifat

Sifat

Total Accepted Answers: 135
Paul Frankowski

Paul Frankowski

Total Accepted Answers: 120
Toufiq

Toufiq

Total Accepted Answers: 65
Pavel

Pavel

Total Accepted Answers: 5
Peter Atkin

Peter Atkin

Total Accepted Answers: 2

100+

Templates

200,000+

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us