From: Garrett R. <GarrettRachelM@JohnDeere.com> - 2011-01-09 02:30:08
|
Greetings, I'm new to Semantic MediaWiki and Semantic Forms. On a fresh install, I'm getting the following error message when I try to access the Special:CreateTemplate page: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SMW::getUnusedPropertySubjects". Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MEMORY' at line 1 (localhost)". Retrieved from "http://localhost/mediawiki/index.php/Special:CreateTemplate" Special:CreateProperty was working fine, and I had created a few properties (mostly strings and text). My wamp server is running PHP 5.3.3 and mySQL 5.5.8. Any ideas on why this could be occurring, and how to fix it? Thanks in advance for your help. Rachel M. Garrett, CAPM IT Associate Technology Analyst, Quality Integration John Deere Financial gar...@jo...<mailto:gar...@jo...> CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. |
From: Yaron K. <ya...@gm...> - 2011-01-09 02:55:43
|
Hi, My guess is that this is some sort of permissions issue; but you can see for yourself, if you add the following to LocalSettings.php: $wgShowSQLErrors = true; -Yaron On Sat, Jan 8, 2011 at 9:29 PM, Garrett Rachel <Gar...@jo... > wrote: > Greetings, > > I'm new to Semantic MediaWiki and Semantic Forms. On a fresh install, I'm > getting the following error message when I try to access the > Special:CreateTemplate page: > > A database query syntax error has occurred. This may indicate a bug in the > software. The last attempted database query was: > (SQL query hidden) > from within function "SMW::getUnusedPropertySubjects". Database returned > error "1064: You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > 'TYPE=MEMORY' at line 1 (localhost)". > Retrieved from " > http://localhost/mediawiki/index.php/Special:CreateTemplate" > > Special:CreateProperty was working fine, and I had created a few properties > (mostly strings and text). > > My wamp server is running PHP 5.3.3 and mySQL 5.5.8. > > Any ideas on why this could be occurring, and how to fix it? > > Thanks in advance for your help. > > Rachel M. Garrett, CAPM > IT Associate Technology Analyst, Quality Integration > John Deere Financial > gar...@jo...<mailto:gar...@jo...> > CONFIDENTIALITY. This electronic mail and any files transmitted with it may > contain information proprietary to Deere & Company, or one of its > subsidiaries or affiliates, and are intended solely for the use of the > individual or entity to whom they are addressed, shall be maintained in > confidence and not disclosed to third parties without the written consent of > the sender. If you are not the intended recipient or the person responsible > for delivering the electronic mail to the intended recipient, be advised > that you have received this electronic mail in error and that any use, > dissemination, forwarding, printing, or copying of this electronic mail is > strictly prohibited. If you have received this electronic mail in error, > please immediately notify the sender by return mail. > > > ------------------------------------------------------------------------------ > Gaining the trust of online customers is vital for the success of any > company > that requires sensitive data to be transmitted over the Web. Learn how to > best implement a security strategy that keeps consumers' information secure > and instills the confidence they need to proceed with transactions. > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: Yury K. <kat...@gm...> - 2011-01-09 08:34:29
|
Hello, Garrett! I had a similar problem when my hosting provider used an rc-version of mysql ( Distrib 5.5.7-rc). In 5.5.7 they got rid of the keyword TYPE (marked as deprecated) and started supporting only the keyword ENGINE. As far as I can see in 5.5.8 the problem is still there. See the details on a mysql manual page: http://dev.mysql.com/doc/refman/5.1/en/create-table.html (Quote) The older TYPE option was synonymous with ENGINE. TYPE has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed in MySQL 5.5. *You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use ENGINE instead*. (End of quote) The problem could be solved with two alternative ways: 1) Install stable version of mysql, for example 5.1.52 OR 2) Replace the keyword MEMORY with the word ENGINE Dear developers, could you add a code that check the version of the mysql and make corresponding forms of query? I used mysql_get_server_info() function to do that in my copy of SMW. Sincerely yours, Yury On Sun, Jan 9, 2011 at 5:29 AM, Garrett Rachel <Gar...@jo... > wrote: > Greetings, > > I'm new to Semantic MediaWiki and Semantic Forms. On a fresh install, I'm > getting the following error message when I try to access the > Special:CreateTemplate page: > > A database query syntax error has occurred. This may indicate a bug in the > software. The last attempted database query was: > (SQL query hidden) > from within function "SMW::getUnusedPropertySubjects". Database returned > error "1064: You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > 'TYPE=MEMORY' at line 1 (localhost)". > Retrieved from " > http://localhost/mediawiki/index.php/Special:CreateTemplate" > > Special:CreateProperty was working fine, and I had created a few properties > (mostly strings and text). > > My wamp server is running PHP 5.3.3 and mySQL 5.5.8. > > Any ideas on why this could be occurring, and how to fix it? > > Thanks in advance for your help. > > Rachel M. Garrett, CAPM > IT Associate Technology Analyst, Quality Integration > John Deere Financial > gar...@jo...<mailto:gar...@jo...> > CONFIDENTIALITY. This electronic mail and any files transmitted with it may > contain information proprietary to Deere & Company, or one of its > subsidiaries or affiliates, and are intended solely for the use of the > individual or entity to whom they are addressed, shall be maintained in > confidence and not disclosed to third parties without the written consent of > the sender. If you are not the intended recipient or the person responsible > for delivering the electronic mail to the intended recipient, be advised > that you have received this electronic mail in error and that any use, > dissemination, forwarding, printing, or copying of this electronic mail is > strictly prohibited. If you have received this electronic mail in error, > please immediately notify the sender by return mail. > > > ------------------------------------------------------------------------------ > Gaining the trust of online customers is vital for the success of any > company > that requires sensitive data to be transmitted over the Web. Learn how to > best implement a security strategy that keeps consumers' information secure > and instills the confidence they need to proceed with transactions. > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- Yury V. Katkov Laboratory of intelligent systems of the Saint-Petersburg National University of Information Technologies, Mechanics and Optics, Russia http://ailab.ifmo.ru |
From: Benedikt K. <ben...@ki...> - 2012-08-23 17:08:19
|
Hello Yury, Thanks for this hint. For clarification, I think you meant: "Replace TYPE=MEMORY with the ENGINE=MEMORY". Best, Benedikt ----- Original Message ----- > From: "Yury Katkov" <kat...@gm...> > To: "Garrett Rachel" <Gar...@jo...> > Cc: sem...@li... > Sent: Sunday, 9 January, 2011 9:34:21 AM > Subject: Re: [Semediawiki-user] Can't access Special:CreateTemplate due to mySQL error > > Hello, Garrett! > I had a similar problem when my hosting provider used an rc-version > of mysql > ( Distrib 5.5.7-rc). In 5.5.7 they got rid of the keyword TYPE > (marked as > deprecated) and started supporting only the keyword ENGINE. As far as > I can > see in 5.5.8 the problem is still there. > > See the details on a mysql manual page: > http://dev.mysql.com/doc/refman/5.1/en/create-table.html > > (Quote) > The older TYPE option was synonymous with ENGINE. TYPE has been > deprecated > since MySQL 4.0 but is still supported for backward compatibility in > MySQL > 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a > warning. It is > removed in MySQL 5.5. *You should not use TYPE in any new > applications, and > you should immediately begin conversion of existing applications to > use > ENGINE instead*. > (End of quote) > > The problem could be solved with two alternative ways: > 1) Install stable version of mysql, for example 5.1.52 OR > 2) Replace the keyword MEMORY with the word ENGINE > > Dear developers, could you add a code that check the version of the > mysql > and make corresponding forms of query? I used > mysql_get_server_info() > function to do that in my copy of SMW. > > Sincerely yours, > Yury > On Sun, Jan 9, 2011 at 5:29 AM, Garrett Rachel > <Gar...@jo... > > wrote: > > > Greetings, > > > > I'm new to Semantic MediaWiki and Semantic Forms. On a fresh > > install, I'm > > getting the following error message when I try to access the > > Special:CreateTemplate page: > > > > A database query syntax error has occurred. This may indicate a bug > > in the > > software. The last attempted database query was: > > (SQL query hidden) > > from within function "SMW::getUnusedPropertySubjects". Database > > returned > > error "1064: You have an error in your SQL syntax; check the manual > > that > > corresponds to your MySQL server version for the right syntax to > > use near > > 'TYPE=MEMORY' at line 1 (localhost)". > > Retrieved from " > > http://localhost/mediawiki/index.php/Special:CreateTemplate" > > > > Special:CreateProperty was working fine, and I had created a few > > properties > > (mostly strings and text). > > > > My wamp server is running PHP 5.3.3 and mySQL 5.5.8. > > > > Any ideas on why this could be occurring, and how to fix it? > > > > Thanks in advance for your help. > > > > Rachel M. Garrett, CAPM > > IT Associate Technology Analyst, Quality Integration > > John Deere Financial > > gar...@jo...<mailto:gar...@jo...> > > CONFIDENTIALITY. This electronic mail and any files transmitted > > with it may > > contain information proprietary to Deere & Company, or one of its > > subsidiaries or affiliates, and are intended solely for the use of > > the > > individual or entity to whom they are addressed, shall be > > maintained in > > confidence and not disclosed to third parties without the written > > consent of > > the sender. If you are not the intended recipient or the person > > responsible > > for delivering the electronic mail to the intended recipient, be > > advised > > that you have received this electronic mail in error and that any > > use, > > dissemination, forwarding, printing, or copying of this electronic > > mail is > > strictly prohibited. If you have received this electronic mail in > > error, > > please immediately notify the sender by return mail. > > > > > > ------------------------------------------------------------------------------ > > Gaining the trust of online customers is vital for the success of > > any > > company > > that requires sensitive data to be transmitted over the Web. > > Learn how to > > best implement a security strategy that keeps consumers' > > information secure > > and instills the confidence they need to proceed with transactions. > > http://p.sf.net/sfu/oracle-sfdevnl > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > -- > Yury V. Katkov > Laboratory of intelligent systems > of the Saint-Petersburg National University of Information > Technologies, > Mechanics and Optics, Russia > http://ailab.ifmo.ru > ------------------------------------------------------------------------------ > Gaining the trust of online customers is vital for the success of any > company > that requires sensitive data to be transmitted over the Web. Learn > how to > best implement a security strategy that keeps consumers' information > secure > and instills the confidence they need to proceed with transactions. > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- AIFB, Karlsruhe Institute of Technology (KIT) Phone: +49 721 608-47946 Email: ben...@ki... Web: http://www.aifb.kit.edu/web/Hauptseite/en |
From: Yury K. <kat...@gm...> - 2012-08-23 21:02:31
|
Yes, that was my typo, thanks! ----- Yury Katkov On Thu, Aug 23, 2012 at 9:08 PM, Benedikt Kämpgen <ben...@ki...> wrote: > Hello Yury, > > Thanks for this hint. > > For clarification, I think you meant: > > "Replace TYPE=MEMORY with the ENGINE=MEMORY". > > Best, > > Benedikt > > ----- Original Message ----- >> From: "Yury Katkov" <kat...@gm...> >> To: "Garrett Rachel" <Gar...@jo...> >> Cc: sem...@li... >> Sent: Sunday, 9 January, 2011 9:34:21 AM >> Subject: Re: [Semediawiki-user] Can't access Special:CreateTemplate due to mySQL error >> >> Hello, Garrett! >> I had a similar problem when my hosting provider used an rc-version >> of mysql >> ( Distrib 5.5.7-rc). In 5.5.7 they got rid of the keyword TYPE >> (marked as >> deprecated) and started supporting only the keyword ENGINE. As far as >> I can >> see in 5.5.8 the problem is still there. >> >> See the details on a mysql manual page: >> http://dev.mysql.com/doc/refman/5.1/en/create-table.html >> >> (Quote) >> The older TYPE option was synonymous with ENGINE. TYPE has been >> deprecated >> since MySQL 4.0 but is still supported for backward compatibility in >> MySQL >> 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a >> warning. It is >> removed in MySQL 5.5. *You should not use TYPE in any new >> applications, and >> you should immediately begin conversion of existing applications to >> use >> ENGINE instead*. >> (End of quote) >> >> The problem could be solved with two alternative ways: >> 1) Install stable version of mysql, for example 5.1.52 OR >> 2) Replace the keyword MEMORY with the word ENGINE >> >> Dear developers, could you add a code that check the version of the >> mysql >> and make corresponding forms of query? I used >> mysql_get_server_info() >> function to do that in my copy of SMW. >> >> Sincerely yours, >> Yury >> On Sun, Jan 9, 2011 at 5:29 AM, Garrett Rachel >> <Gar...@jo... >> > wrote: >> >> > Greetings, >> > >> > I'm new to Semantic MediaWiki and Semantic Forms. On a fresh >> > install, I'm >> > getting the following error message when I try to access the >> > Special:CreateTemplate page: >> > >> > A database query syntax error has occurred. This may indicate a bug >> > in the >> > software. The last attempted database query was: >> > (SQL query hidden) >> > from within function "SMW::getUnusedPropertySubjects". Database >> > returned >> > error "1064: You have an error in your SQL syntax; check the manual >> > that >> > corresponds to your MySQL server version for the right syntax to >> > use near >> > 'TYPE=MEMORY' at line 1 (localhost)". >> > Retrieved from " >> > http://localhost/mediawiki/index.php/Special:CreateTemplate" >> > >> > Special:CreateProperty was working fine, and I had created a few >> > properties >> > (mostly strings and text). >> > >> > My wamp server is running PHP 5.3.3 and mySQL 5.5.8. >> > >> > Any ideas on why this could be occurring, and how to fix it? >> > >> > Thanks in advance for your help. >> > >> > Rachel M. Garrett, CAPM >> > IT Associate Technology Analyst, Quality Integration >> > John Deere Financial >> > gar...@jo...<mailto:gar...@jo...> >> > CONFIDENTIALITY. This electronic mail and any files transmitted >> > with it may >> > contain information proprietary to Deere & Company, or one of its >> > subsidiaries or affiliates, and are intended solely for the use of >> > the >> > individual or entity to whom they are addressed, shall be >> > maintained in >> > confidence and not disclosed to third parties without the written >> > consent of >> > the sender. If you are not the intended recipient or the person >> > responsible >> > for delivering the electronic mail to the intended recipient, be >> > advised >> > that you have received this electronic mail in error and that any >> > use, >> > dissemination, forwarding, printing, or copying of this electronic >> > mail is >> > strictly prohibited. If you have received this electronic mail in >> > error, >> > please immediately notify the sender by return mail. >> > >> > >> > ------------------------------------------------------------------------------ >> > Gaining the trust of online customers is vital for the success of >> > any >> > company >> > that requires sensitive data to be transmitted over the Web. >> > Learn how to >> > best implement a security strategy that keeps consumers' >> > information secure >> > and instills the confidence they need to proceed with transactions. >> > http://p.sf.net/sfu/oracle-sfdevnl >> > _______________________________________________ >> > Semediawiki-user mailing list >> > Sem...@li... >> > https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > >> >> >> >> -- >> Yury V. Katkov >> Laboratory of intelligent systems >> of the Saint-Petersburg National University of Information >> Technologies, >> Mechanics and Optics, Russia >> http://ailab.ifmo.ru >> ------------------------------------------------------------------------------ >> Gaining the trust of online customers is vital for the success of any >> company >> that requires sensitive data to be transmitted over the Web. Learn >> how to >> best implement a security strategy that keeps consumers' information >> secure >> and instills the confidence they need to proceed with transactions. >> http://p.sf.net/sfu/oracle-sfdevnl >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > > -- > AIFB, Karlsruhe Institute of Technology (KIT) > Phone: +49 721 608-47946 > Email: ben...@ki... > Web: http://www.aifb.kit.edu/web/Hauptseite/en > > |