John Rybak
John Rybak
Offline
been having issues with the slideshow on the main page ever since my first upgrade. I keep getting an error message.
Thursday, December 22 2016, 12:02 AM
Share this post:

Accepted Answer

Saturday, December 31 2016, 03:56 PM - #Permalink
Someone with some basic knowledge about MySQL should investigate your database, to see what else is missing. If it's only this one table, or if all updates for 1.4.x and 1.5.x has failed. If you have no friend you trust, to give access to your database to investigate and fix it, you might need to hire someone to help you.

With your skills it would be a lot of hand holding and replies back and forth, and risk of more serious trouble, doing all this through a forum ...

But let us test something, but be warn - you might break things. Ensure you take a valid backup first, and learn how to restore it.

1. Check your database to see if the table named "banner_image_description" exists, if you don't find it, skip the rest.

2. If it's there, install the attached file from https://arastta.org/docs/user-manual/extensions/extension-installer

3. Test your banners, and everything else in your system.

4. If all is fine, good, enjoy. Else, restore the backup and get someone to help you.
The reply is currently minimized Show
Responses (11)
  • Accepted Answer

    Thursday, December 22 2016, 01:09 AM - #Permalink
    Was that all info you could provide? Seriously?

    Your first upgrade, from what to what?
    And the error message is?

    Come on, you can do better ... ;)
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Saturday, December 24 2016, 11:41 PM - #Permalink
    Tried to post more, but it wouldn't let me post then it thought i was spamming.

    First noticed when I upgraded to 1.4 I think.

    Error message i get is:

    Notice: Error: Unknown column 'language id' in 'where clause'
    Error No: 1045
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Saturday, December 24 2016, 11:46 PM - #Permalink
    this is the rest of the error message
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 25 2016, 02:03 PM - #Permalink
    John Rybak wrote:
    Tried to post more, but it wouldn't let me post then it thought i was spamming.

    You could have added that info then, so this sites admin could help with it. But yeah, they know their firewall sucks, as I already has told them they should switch ...

    John Rybak wrote:
    Notice: Error: Unknown column 'language id' in 'where clause'
    Error No: 1045

    Then the question is how you do your upgrades, since it seems like you haven't run the upgrade script, that should add this new column in the 1.4 update.

    But since it's missing you probably need to add it manually then, and also all other missing changes according to your version:
    https://github.com/arastta/arastta/blob/master/install/update.php#l353-l535
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Sunday, December 25 2016, 08:40 PM - #Permalink
    I have been doing all of my updates through the admin panel and clicking update. Thats the main reason I went with Arastta in the first place.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, December 26 2016, 02:04 PM - #Permalink
    OK, but the update hasn't been added as it should for some reason. And you need to fix that then.
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Tuesday, December 27 2016, 07:46 AM - #Permalink
    My system says I'm now running v1.5.

    Which file to I need to manually enter the updates?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 27 2016, 12:36 PM - #Permalink
    In your MySQL database, through phpMyAdmin or other tool.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, December 30 2016, 01:36 PM - #Permalink
    I added a "Feature Request" to the GH issues, that would be very helpful in cases like this:
    https://github.com/arastta/arastta/issues/636
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Friday, December 30 2016, 10:01 PM - #Permalink
    Where in the database is this located, I cannot seem to find it. It appears that I need someone to hold my hand through this whole process :)
    The reply is currently minimized Show
  • Accepted Answer

    John Rybak
    John Rybak
    Offline
    Saturday, December 31 2016, 08:37 PM - #Permalink
    That seems to have solved the issue. Many Thanks:D
    Like
    1
    The reply is currently minimized Show
Your Reply