Archived talk:Developing a MVC Component/Using the database - Revision history

M-b-o: M-b-o moved page J2.5 talk:Developing a MVC Component/Using the database to Archived talk:Developing a MVC Component/Using the database

2022-04-26T22:18:52Z

M-b-o moved page J2.5 talk:Developing a MVC Component/Using the database to Archived talk:Developing a MVC Component/Using the database

← Older revision	Revision as of 22:18, 26 April 2022
(No difference)

Ncramp: /* Provide method to alter BOM for SQL files */

2015-02-21T22:39:43Z

Provide method to alter BOM for SQL files

← Older revision		Revision as of 22:39, 21 February 2015
Line 117:		Line 117:
	I then ran the following terminal command, which removed BOM and saved new files in Joomla naming spec.		I then ran the following terminal command, which removed BOM and saved new files in Joomla naming spec.

			<source lang="php">
	nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' install.sql > install.mysql.utf8.sql		nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' install.sql > install.mysql.utf8.sql
	nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' uninstall.sql > uninstall.mysql.utf8.sql		nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' uninstall.sql > uninstall.mysql.utf8.sql
			</source>

	I make new files because comparing the filesizes gives an indication that the command was carried out - a little sanity check before zipping the archive etc.		I make new files because comparing the filesizes gives an indication that the command was carried out - a little sanity check before zipping the archive etc.

Ncramp: Provide method to alter BOM for SQL files

2015-02-21T22:38:02Z

Provide method to alter BOM for SQL files

← Older revision		Revision as of 22:38, 21 February 2015
Line 109:		Line 109:
	[[User:AnthonyGeoghegan\|AnthonyGeoghegan]] ([[User talk:AnthonyGeoghegan\|talk]]) 08:49, 29 May 2013 (CDT)		[[User:AnthonyGeoghegan\|AnthonyGeoghegan]] ([[User talk:AnthonyGeoghegan\|talk]]) 08:49, 29 May 2013 (CDT)

	=== Provide method to alter BOM for SQL files ===		== Provide method to alter BOM for SQL files ==

	I had a problem getting this part of the MVC tutorial to work - the issue due to BOM being included in the SQL file as the documentation correctly makes aware to readers. I did not have a editor available for my Linux OS with a easy way to remove BOM. I used the following steps instead, which may be useful for others:		I had a problem getting this part of the MVC tutorial to work - the issue due to BOM being included in the SQL file as the documentation correctly makes aware to readers. I did not have a editor available for my Linux OS with a easy way to remove BOM. I used the following steps instead, which may be useful for others:
Line 127:		Line 127:

	This worked for me pretty well, might be useful for others too.		This worked for me pretty well, might be useful for others too.
			[[User:Ncramp\|Ncramp]] ([[User talk:Ncramp\|talk]]) 16:38, 21 February 2015 (CST)

Ncramp: Provide method to alter BOM for SQL files

2015-02-21T22:35:23Z

Provide method to alter BOM for SQL files

← Older revision		Revision as of 22:35, 21 February 2015
Line 108:		Line 108:
	</span>		</span>
	[[User:AnthonyGeoghegan\|AnthonyGeoghegan]] ([[User talk:AnthonyGeoghegan\|talk]]) 08:49, 29 May 2013 (CDT)		[[User:AnthonyGeoghegan\|AnthonyGeoghegan]] ([[User talk:AnthonyGeoghegan\|talk]]) 08:49, 29 May 2013 (CDT)

			=== Provide method to alter BOM for SQL files ===

			I had a problem getting this part of the MVC tutorial to work - the issue due to BOM being included in the SQL file as the documentation correctly makes aware to readers. I did not have a editor available for my Linux OS with a easy way to remove BOM. I used the following steps instead, which may be useful for others:

			First i prepared the SQL statements from the tutorial in two files: install.sql and uninstall.sql.

			I then ran the following terminal command, which removed BOM and saved new files in Joomla naming spec.

			nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' install.sql > install.mysql.utf8.sql
			nathan@T3-ibm:/var/www/helloworld/admin/sql$ awk '{if(NR==1)sub(/^\xef\xbb\xbf/,"");print}' uninstall.sql > uninstall.mysql.utf8.sql

			I make new files because comparing the filesizes gives an indication that the command was carried out - a little sanity check before zipping the archive etc.

			These files can be deleted.

			What is required now is to copy and paste the install.mysql.utf8.sql file to helloworld/admin/sql/updates/mysql, and rename the file as 0.0.6.sql

			This worked for me pretty well, might be useful for others too.

AnthonyGeoghegan: /* Backticks in MySQL code preventing table prefix expansion */

2013-05-29T13:49:49Z

Backticks in MySQL code preventing table prefix expansion

← Older revision		Revision as of 13:49, 29 May 2013
Line 107:		Line 107:
	</source>		</source>
	</span>		</span>
			[[User:AnthonyGeoghegan\|AnthonyGeoghegan]] ([[User talk:AnthonyGeoghegan\|talk]]) 08:49, 29 May 2013 (CDT)

AnthonyGeoghegan: /* Backticks in MySQL code preventing table prefix expansion */ new section

2013-05-29T13:46:41Z

Backticks in MySQL code preventing table prefix expansion: new section

← Older revision		Revision as of 13:46, 29 May 2013
Line 85:		Line 85:
	<message><![CDATA[COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_DESC]]></message>		<message><![CDATA[COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_DESC]]></message>
	Now I have the functionality described in the tutorial.		Now I have the functionality described in the tutorial.

			== Backticks in MySQL code preventing table prefix expansion ==

			I'm new to Joomla but I was getting errors when I used the MySQL specified for '''admin/sql/install.mysql.utf8.sql'''
			The #__ wasn't being replaced with the configured table prefix so it was trying to create a table named '''#__helloworld '''instead of '''jos_helloworld'''. I was able to resolve this by removing the backticks from the MySQL file.

			<span id="admin/sql/install.mysql.utf8.sql">
			''admin/sql/install.mysql.utf8.sql'' and ''admin/sql/updates/mysql/0.0.6.sql''
			<source lang="sql">
			DROP TABLE IF EXISTS #__helloworld;

			CREATE TABLE #__helloworld (
			id int(11) NOT NULL AUTO_INCREMENT,
			greeting varchar(25) NOT NULL,
			PRIMARY KEY (id)
			) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

			INSERT INTO #__helloworld (greeting) VALUES
			('Hello Database World!'),
			('Goodbye Database World!');
			</source>
			</span>

Tom Hutchison: Hutchy68 moved page J2.5 talk:Developing a Model-View-Controller Component/Using the database to J2.5 talk:Developing a MVC Component/Using the database: trying to shorten title

2013-05-03T19:46:51Z

Hutchy68 moved page J2.5 talk:Developing a Model-View-Controller Component/Using the database to J2.5 talk:Developing a MVC Component/Using the database: trying to shorten title

← Older revision	Revision as of 19:46, 3 May 2013
(No difference)

Tom Hutchison: Hutchy68 moved page Talk:Developing a Model-View-Controller Component/2.5/Using the database to J2.5 talk:Developing a Model-View-Controller Component/Using the database: namespacing

2013-05-03T19:38:15Z

Hutchy68 moved page Talk:Developing a Model-View-Controller Component/2.5/Using the database to J2.5 talk:Developing a Model-View-Controller Component/Using the database: namespacing

← Older revision	Revision as of 19:38, 3 May 2013
(No difference)

AntsV: /* Error in sample code */ new section

2012-12-28T09:28:25Z

Error in sample code: new section

← Older revision		Revision as of 09:28, 28 December 2012
Line 77:		Line 77:

	The code is different from the archive. msg instead of messages!		The code is different from the archive. msg instead of messages!

			== Error in sample code ==

			I've also spent half a day with some of the problems described above, namely lost parameter and no message selection list in menu item. Solution that worked for me was a small change in default.xml.
			<message>COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_DESC</message>
			should be
			<message><![CDATA[COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_DESC]]></message>
			Now I have the functionality described in the tutorial.

Chris Davenport: moved Talk:Developing a Model-View-Controller (MVC) Component for Joomla!2.5 - Part 06 to Talk:Developing a Model-View-Controller Component/2.5/Using the database: Improve structure with subpages and version disambiguation.

2012-08-06T19:31:34Z

moved Talk:Developing a Model-View-Controller (MVC) Component for Joomla!2.5 - Part 06 to Talk:Developing a Model-View-Controller Component/2.5/Using the database: Improve structure with subpages and version disambiguation.

← Older revision	Revision as of 19:31, 6 August 2012
(No difference)