Home » Forum
NoNumber!

Joomla!® Websites & Extensions
development  -  support  -  consultancy

I try to respond within 48 hours (excluding weekends).
If I haven't responded by then, feel free to post a reminder or bug me via email.

My last reply was: 2 Hours, 31 Minutes ago.

Welcome, Guest
Please Login or Register.    Lost Password?

Error during upgrade / install
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Error during upgrade / install
#1675
Error during upgrade / install 2 Years, 12 Months ago  
JDatabaseMySQL::query: 1054 - Unknown column 'text' in 'jos_contenttemplater' SQL=ALTER TABLE `jos_contenttemplater` CHANGE `text` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

I tried to uninstall the old version (0.3.0.) and even to DROP table jos_contenttemplater but got the same error every time!

Can you help me? 0.3.0 worked perfect!
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1676
Error during upgrade / install 2 Years, 12 Months ago  
The line that does that is to fix the Content Templater table from version 0.1.0.
So it is not necessary.
In the tests I ran, the query just got ignored if it couldn't get executed. I'm not sure why your setup does return the error. What Joomla version are you running?

Please install the extension manually (see the INSTALL.txt in the package zip).
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1686
Error during upgrade / install 2 Years, 11 Months ago  
Joomla 1.5.9 (current)

I managed to install using a little bit workaround...
I created manually TEXT field in table contenttemplater... so the setup ran smoothly
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1687
Error during upgrade / install 2 Years, 11 Months ago  
I forgot to say thanks!

Keep up the good work.
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1688
Error during upgrade / install 2 Years, 11 Months ago  
oh... problems again!


A newer version is available. Download version 0.3.1

The package will automatically update your version.
(This message will only be displayed to (Super) Administrators.)

WTF?! I'm sure I had 0.3.1 listed in components install/uninstall module..

Now it's giving me option to upgrade again?!?!
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1689
Error during upgrade / install 2 Years, 11 Months ago  
Strange... I downloaded again the 0.3.1 package and installed without removing the old version...

And it was OK!
Result:

Content Templater Enabled 0.3.1 February 2009 NoNumber! (Peter van Westen)

That would suppose to mean I'm running the current version at last?
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1693
Error during upgrade / install 2 Years, 11 Months ago  
With your first install, something went wrong, so your files did not get updated (completely).
The second install did not run into the database error so it updated all files.

The version check is done by simply looking at a small text file with the version number.
So even if all files are up to date except that little file, you will get the update message.

Content Templater (and the installation procedure) are still in beta, so you can expect updates coming along quite frequently.
If you want to be informed about updates and what has actually changed, you can subscripe to my News RSS.
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1713
Error during upgrade / install 2 Years, 11 Months ago  
OK, thanks!
I just hope that even it is in beta stage, next upgrade won't do such a mess cuz' I'm right now creating main template look with Content templater and the content is about to be published... 50+ articles with the same layout created by your extension..

I'm informed about updates every time I visit CT component as an super admin So no prob... but thanks anyway!

Groeten!
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1715
Error during upgrade / install 2 Years, 11 Months ago  
New version upgrade...

different server, completely different J 1.5.9. installation, only problem stays the same:

500 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'text' in 'jos_contenttemplater' SQL=ALTER TABLE `jos_contenttemplater` CHANGE `text` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

So I better stick to an old version?
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1716
Error during upgrade / install 2 Years, 11 Months ago  
Hmmm, you are the second person complaining about that error.

It doesn't happen on any of my setups. That query (as you can see) is done through the joomla core datbase functions, which should just ignore queries that cannot be done.

Anyway, the query that gives the error is not needed anyway, it is to fix some stuff from version 0.1.0. I can assume noo-ne is using that version anymore, so I'll take it out.

Version 0.3.3 coming in a few minutes
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1717
Error during upgrade / install 2 Years, 11 Months ago  
Ok, 0.3.3 is available.

Just to note, these are minor updates (x.x.?), so you don't need to update if the changes are not interesting for you.

If I change something that is fundamentally different, it will be a x.?.x version change.

If I change it so much that the way it works (for the user) changes, then it will be a ?.x.x version change. (Or when going to stable.)
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1718
Error during upgrade / install 2 Years, 11 Months ago  
Hello Peter,
I managed to find out what was causing the problem during install/upgrade..

I deleted all content templater items (I need to make new one anyway) so the upgrade to 0.3.3. was completely OK!



* Content Templater (component & editor button) has been updated successfully





I hope this would help you to deal with this bug, I'm sure anyone who got one item in CT would get the same error... all he/she need to do is to delete all items and to go to upgrade process.
It's not good solution if you are on a production environment and your Content template is 100% done, it would be good to have an option to backup... or to deal with this bug.

Cheers
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1719
Error during upgrade / install 2 Years, 11 Months ago  
Well, the update should work fine even if you have items.

The upgrade is pretty useless if you have to delete the templates first.

If you run the update (0.3.3) again with items, do you run into errors again?
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1720
Error during upgrade / install 2 Years, 11 Months ago  
You mean I should run again update, I have version 0.3.3 version already?


I can try - I'll create one test item, and then run update again...

let's see what happens.
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1721
Error during upgrade / install 2 Years, 11 Months ago  
OHHH...

I can't do that!!!

Can't add NEW Item!!

JDatabaseMySQL::query: 1146 - Table 'mysitename_com.jos_js_res_category' doesn't exist SQL=SELECT id, parent, name FROM jos_js_res_category WHERE published = 1
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1722
Error during upgrade / install 2 Years, 11 Months ago  
So you do have the JoomSource files in your setup, but you don't have the database!
I'll build in another check to prevent this error...
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1723
Error during upgrade / install 2 Years, 11 Months ago  
Sorry, It's my fault... I have a few lines commented out

Will fix now...
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1724
Error during upgrade / install 2 Years, 11 Months ago  
I'm glad this situation helped you... to kill that bug!

Please let me know what should I do next, I deleted again Jos_conetentemplater table from my database... I'm gonna start all over again when you come out with a new version... hope it will be soon.
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
#1725
Error during upgrade / install 2 Years, 11 Months ago  
Should be fixed in version 0.3.4. Now available:
http://www.nonumber.nl/contenttemplater/download
Peter van Westen
Admin
Posts: 9169
User Online NowClick here to see the profile of this user
The administrator has disabled public write access.
Need to contact me directly? Go to my contact page.
If you use any NoNumber! extensions, please post a rating and a review at the Joomla! Extensions Directory.
Are you happy with the support? Please consider buying a License Code to help me to continue development and support.
 
#1726
Error during upgrade / install 2 Years, 11 Months ago  
It works!!!
I tested on my other server / joomla installation and 2 content items from the templater was left and after upgrade they're still there and I can go to NEW button and add new ones!

I think you did it, the bug is dead!!!

Thanks a lot Peter!!

P.S. I'd like to donate (pro version), but in my country Paypal is N/A (grrrr), so I'm using Moneybookers without any problems so if you have an account please send it on my private message...
Maxime Verhagen
Posts: 16
User OfflineClick here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
Moderators: Peter van Westen
Open Source Training | Online Joomla! Training and Support
MaxCDN | Content Delivery Network | Accelerate your site to the max
hosting joomla