- Posts: 448
- Thank you received: 2
SOLVED- upgrade db
- sti
- Topic Author
- Offline
- Platinum Member
-
Databases
Table : #__osrs_configuration, #__osrs_watermark
how do i perform this please.
thanks
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
'
can u send me pls/
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
- Posts: 13020
- Thank you received: 1688
You don't see the product in My download part?
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
- Posts: 13020
- Thank you received: 1688
admin/sql/install.osproperty.sql
and the new data for table
#__osrs_configuration
is in file
admin/sql/configuration.osproperty.sql
P/s: I just updated the latest version 2.0.4.5
Dam
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
Dang Thuc Dam wrote: Hi,
You don't see the product in My download part?
Thanks
Dam
download is 2.0.4.5
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
Dang Thuc Dam wrote: You can find the table #__osrs_watermark in the folder of component (after download and extract zip file com_osproperty.j2.5.5_j3.x.zip
admin/sql/install.osproperty.sql
and the new data for table
#__osrs_configuration
is in file
admin/sql/configuration.osproperty.sql
P/s: I just updated the latest version 2.0.4.5
Dam
if were to import the configuration.osproperty.sql i am sure all my data will be replace by your data.
i think ill just export , compare and import back
btw
goole_aip_key' ?> its google api key. ?
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
(194, 'watermark_text', '2'),
(195, 'custom_text', ''),
(196, 'watermark_all', '1'),
(197, 'watermark_photo', ''),
(198, 'watermark_position', '5'),
(199, 'custom_thumbnail_photo', '1'),
(200, 'watermark_fontsize', '10'),
(201, 'watermark_color', '246,151,16'),
(202, 'default_list_view', '1');
there are the new db i guess.
is the front number very important same as the file db?
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
please make the upgrading process easier for manual upgrading .
one way of doing it is as above create a custom update mysql file for each table which the function like (dont overwrite data is exist etc) and second by preserving the old data strructure example
old
(137, 'listing_show_ncomments', '1'), >> (144, 'listing_show_ncomments', '1'),
practically i cant update anything now and i m not sure how others did update and preserve old data, if you guys manage to do it please share
thanks
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
- Posts: 13020
- Thank you received: 1688
Regards,
Dam
Please Log in or Create an account to join the conversation.
- sti
- Topic Author
- Offline
- Platinum Member
-
- Posts: 448
- Thank you received: 2
thanks!
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.