mysql-Update-Files not executed by Update

For Joomla! 3.x Coding related discussions, please use: http://groups.google.com/group/joomla-dev-general

Moderator: ooffick

Forum rules
Please use the mailing list here: http://groups.google.com/group/joomla-dev-general rather than this forum.
Post Reply
tria1312
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Oct 05, 2006 9:32 pm

mysql-Update-Files not executed by Update

Post by tria1312 » Sun Sep 09, 2018 10:00 pm

Hi all,

I'd like to my update-file which I have stored in sql/updates/mysql/01.01.02.sql to be executed when the user updates my component from version 01.01.01 to version 01.01.02.
But it doesn't.

Here is my code:

Code: Select all

	<update>
		<schemas>
			<schemapath type="mysql">sql/updates/mysql</schemapath>
		</schemas>
	</update>
After the update the database changes are not done.

What is wrong or what do I have to check?


Best Regards
tria1312

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 35487
Joined: Sat Apr 05, 2008 9:58 pm

Re: mysql-Update-Files not executed by Update

Post by Webdongle » Sun Sep 09, 2018 10:59 pm

Please describe how you are attempting to update.
Also please viewtopic.php?f=714&t=793531
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

tria1312
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Oct 05, 2006 9:32 pm

Re: mysql-Update-Files not executed by Update

Post by tria1312 » Mon Sep 10, 2018 7:35 pm

I have an Updateserver on my own Webserver. The update download of the updates from that server ist working.
But when Joomla ist installing all the files on the server an tries to update the database, it seems the sql-Statement files are not found or not used ... I do not know.
My files are name like:

Code: Select all

sql/updates/mysql/01.01.02.sql 
or

Code: Select all

sql/updates/mysql/01.01.03.sql 
The content of these files are working correctly. I have tested this before directly on my testing database.

Is there a possibility to test the update process in an easy manor?


Best Regards
tria1312

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 35487
Joined: Sat Apr 05, 2008 9:58 pm

Re: mysql-Update-Files not executed by Update

Post by Webdongle » Mon Sep 10, 2018 8:04 pm

We can not help you with the inadequacies of your server.

The correct way of updating Joomla is https://docs.joomla.org/J3.x:Updating_f ... ng_version
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

tria1312
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Oct 05, 2006 9:32 pm

Re: mysql-Update-Files not executed by Update

Post by tria1312 » Mon Sep 10, 2018 8:14 pm

Hi,

this is the way an update is usually done in Joomla. Yes. And my component follows exactly that way and it fetches the updates from my own update server. There is nothing inadequate.
The problem is in the behavior how Joomla updates the mySQL-Database or the way I understand the behavior.

My server is ok. And also the update process is ok. But what does Joomla do with the mySQL-Update files. Where does Joomla search form them (I gave the right pathes in the component PHP-File)? Is it written correctly? Do I have a slash at the right position or is there someting missing.
This is what I expect from the experts here to answer.

Does anyone know, how to fix my problem? Or at least, how to debug it instead of counter the version numbers up and up and up?


BTW: Here is the link with explanations how to create an update server:https://docs.joomla.org/J3.x:Developing ... ate_server

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 35487
Joined: Sat Apr 05, 2008 9:58 pm

Re: mysql-Update-Files not executed by Update

Post by Webdongle » Mon Sep 10, 2018 8:38 pm

Oh you are updating your component not Joomla?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein


Post Reply

Return to “Joomla! 3.x Coding”