Railo 4.1.2.005 Error (database)
Message
DetailIncorrect key file for table '\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\#sql53c_e25_51.MYI'; try to repair it
SQL

SELECT

cms_post.*,

cms_channel.slug as "channel_slug",
cms_channel.name as "channel_name",
cms_image.image,


if(post_type = 'link', url_ext, concat ("", "/", cms_channel.slug, "/", cms_post.slug, ".phtml"))
as "permalink",

cms_post_listed_channel.channel_id as "otherchannel_id",

getChannelSlug(cms_post_listed_channel.channel_id) as "otherchannel_slug",

cms_image.credit as "image_credit",
cms_image.caption as "image_caption",
cms_image.title as "image_title",
cms_image.slug as "image_slug",
cms_image.path_legacy as "image_path_legacy",

cms__user.id as "author_id",
cms__user.username as "author_username",
cms__user.first_name as "author_firstname",
cms__user.lastname as "author_lastname",
cms__user.email as "author_email",
cms__user.twitter as "author_twitter",
cms__user.facebook as "author_facebook",
cms__user.instagram as "author_instagram",
cms__user.googleplus as "author_googleplus",
cms__user.blogsite as "author_blogsite",
cms__user.about as "author_about",

regex_replace('[^a-zA-Z0-9\-]','',lcase(concat(cms__user.first_name,'-', cms__user.lastname))) as "author_slug"

FROM

cms_post, cms_channel, cms_image , cms_post_listed_channel, cms__user

WHERE
cms_post.site_id = 2 AND

cms_post.deleted = 'N' AND
cms_post.published = 1 AND
cms_post.date_available < NOW() AND

cms_post.channel_id = cms_channel.id AND
cms_post.main_image_id = cms_image.id AND
cms_post.user_id = cms__user.id AND

cms_post.id = cms_post_listed_channel.post_id

ORDER BY
cms_post.date_available DESC

LIMIT 3000;

DatabaseNameMySQL
DatabaseVersion5.6.37-log
DriverNameMySQL-AB JDBC Driver
DriverVersionmysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasourceorinoco
StacktraceThe Error Occurred in
C:\Fast-CMS\webapps\www\orinoco\publicador\console\application-content-templates.cfm: line 609
607:
608: WHERE
609: cms_post.site_id = #CodeSiteId# AND
610:
611: cms_post.deleted = 'N' AND

called from C:\Fast-CMS\webapps\www\orinoco\publicador\application.cfm: line 13
Java Stacktrace
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073):1073
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951):951
  at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1929):1929
  at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3412):3412
  at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:481):481
  at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3118):3118
  at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2288):2288
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2709):2709
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677):2677
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681
  at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
  at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
  at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:209):209
  at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
  at railo.runtime.tag.Query.executeDatasoure(Query.java:656):656
  at railo.runtime.tag.Query.doEndTag(Query.java:502):502
  at orinoco.publicador.console.application_content_templates_cfm1440$cf.call(C:\Fast-CMS\webapps\www\orinoco\publicador\console\application-content-templates.cfm:609):609
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:809):809
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:785):785
  at orinoco.publicador.application_cfm$cf.call(C:\Fast-CMS\webapps\www\orinoco\publicador\application.cfm:13):13
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:809):809
  at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:30):30
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2135):2135
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2102):2102
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848
  at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686):686
  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501):501
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137
  at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557
  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231
  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086
  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428):428
  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193
  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135
  at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255):255
  at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116
  at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:317):317
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116
  at org.eclipse.jetty.server.Server.handle(Server.java:370):370
  at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489):489
  at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949):949
  at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011):1011
  at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644
  at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235
  at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668):668
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52
  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608
  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543
  at java.lang.Thread.run(Unknown Source):-1
 
Timestamp1/22/18 9:00:07 AM ART

');if(document.referrer != undefined&&(document.referrer.indexOf('www.perfil.com')>0||document.referrer.indexOf('m.perfil.com')>0)){ enablePerfilHeader();}}); var displayBack = false; function enablePerfilHeader(){jQuery('div.contBar').css('display','block');displayBack=true;jQuery('body').css('margin-top','0');} function goBack(){window.history.back();} jQuery(window).scroll(function(){if(jQuery(this).scrollTop()>100&&displayBack){jQuery('.goBack').fadeIn();}else{jQuery('.goBack').fadeOut();}});

FORTUNA WEB

Youtube

G Plus

Facebook

Twitter

 

Negocios

18/03/2011

Coca Cola Diet superó en ventas a Pepsi en Estados Unidos

Por primera vez, la bebida sin calorías se convirtió en la segunda marca del mercado estadounidense. Tras un cambio de estrategia en su publicidad, Pepsi terminó el 2010 en el tercer puesto.

Coca Cola Diet, la gaseosa sin calorías de la multinacional Coca-Cola Company, se convirtió en la segunda marca de bebida más vendida en Estados Unidos, detrás de la versión tradicional de esta misma marca. Superó en ventas por primera vez a su competidor Pepsi.

Así lo anunció la publicación sectorial Beverage Digest. De acuerdo a las estadísticas de mercado, el ranking de bebidas (por marca) en EE.UU. es:

  1. Coca Cola – 17% de mercado – 1.590 millones de cajas vendidas en 2010
  2. Coca Cola Diet – 9,9% de mercado – 926,9 millones de cajas
  3. Pepsi – 9,5% de mercado – 891,5 millones de cajas

Durante el año pasado, Pepsi hizo una arriesgado cambio publicitario: Se retiró como auspiciante del Super Bowl (el mayor evento deportivo de EE.UU.) y encausó sus acciones promocionales a través de donaciones de U$S 20 millones para proyectos de innovación.

Entre las diez marcas de bebida gaseosa más populares del mercado estadounidense también se inscriben -del puesto cuatro al diez-: Mountain Dew, Dr Pepper, Sprite, Diet Pepsi, Diet Mountain Dew, Diet Dr. Pepper y Fanta.

Redacción FortunaWeb

18/3/2011

Archivado en: