ParSalian

March 7, 2013

Do you have this tested with a clear MySQL Database ? Otherwise you got the following error.message.

I think you must use "Drop Table if exist " or "Alter Table" instead of "Create Table"

Your SVN 1161 works for me. Only if i try to update to SVN 1163 then i have this error

[Err] 1050 - Table 'cp_itemshop' already exists
[Err] CREATE TABLE `cp_itemshop` (
`id` int(11) unsigned NOT NULL auto_increment,
  `nameid` int(11) unsigned NOT NULL default '0',
  `quantity` int(11) unsigned NOT NULL default '0',
  `cost` int(11) unsigned NOT NULL,
  `info` text,
  `create_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM COMMENT='Item shop';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

March 7, 2013

Hi Xantara,

here the error message.

Critical Error

An error was encountered during the lifetime of the application.

This could be due to a variety of problems, such as a bug in the application.

However, normally it is caused by misconfiguration.

Exception Details

Error: Flux_Error

Message: Critical MySQL error in Installer/Updater: Query was empty

File: C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Installer\Schema.php:133

File	Line	Function/Method
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Installer\Schema.php
157	Flux_Installer_Schema::install()
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Installer\MainServer.php	
46	Flux_Installer_Schema::update()
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\modules\install\index.php	
83	Flux_Installer_MainServer::updateAll()
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Template.php	
337	include()
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Dispatcher.php	
168	Flux_Template::render()
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\index.php	177	Flux_Dispatcher::dispatch()
Exception Trace As String

#0 C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Installer\Schema.php(157): Flux_Installer_Schema->install('20080928225124')
#1 C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Installer\MainServer.php(46): Flux_Installer_Schema->update()
#2
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\modules\install\index.php(83): Flux_Installer_MainServer->updateAll()
#3
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Template.php(337): include('C:\Inetpub\vhos...')
#4
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\lib\Flux\Dispatcher.php(168): Flux_Template->render()
#5
C:\Inetpub\vhosts\h2132250.stratoserver.net\httpdocs\xantara\index.php(177): Flux_Dispatcher->dispatch(Array)
#6
{main}

March 6, 2013

wich version prefer the most and is there any significant different between Calciumkid and Xantara's Version ?

March 6, 2013

i use this FluxCP SVN http://fluxcp-ra.googlecode.com/svn/trunk. Yesterday make Xantara a new Version 1162,1163 and i try to install / update my FluxCP. After the Install / Update Screen there were only a Error Message that i should contact a admin .

I think there's a problem with update / deleted the MySQL databases. Have anybody the same problems ?

Revision: 1162
Author: [email protected]
Date: Dienstag, 5. März 2013 05:28:09
Message:
Renamed schema files to use date & time instead of revision numbers
` Added color coding in installer page
- Table name will be green if that SQL table is up to date, red if it needs to be updated/installed
* This update is to move towards a non-SVN reliant system
----
Deleted : /trunk/data/schemas/charmapdb/cp_charprefs.1051.sql
Added : /trunk/data/schemas/charmapdb/cp_charprefs.20080929191525.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_charprefs.522.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_charprefs.522.sql
Added : /trunk/data/schemas/charmapdb/cp_charprefs.20081109093448.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_charprefs.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_charprefs.743.sql
Added : /trunk/data/schemas/charmapdb/cp_charprefs.20120816150540.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_charprefs.1051.sql, Revision, 1161)
Added : /trunk/data/schemas/charmapdb/cp_itemshop.20080928225124.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_itemshop.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_itemshop.497.sql
Added : /trunk/data/schemas/charmapdb/cp_itemshop.20081109093448.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_itemshop.724.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_itemshop.724.sql
Added : /trunk/data/schemas/charmapdb/cp_itemshop.20081128093449.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_itemshop.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_itemshop.743.sql
Added : /trunk/data/schemas/charmapdb/cp_itemshop.20090104190020.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_itemshop.899.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_itemshop.899.sql
Added : /trunk/data/schemas/charmapdb/cp_redeemlog.20080928225124.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_redeemlog.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_redeemlog.497.sql
Added : /trunk/data/schemas/charmapdb/cp_redeemlog.20081001054354.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_redeemlog.554.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_redeemlog.554.sql
Added : /trunk/data/schemas/charmapdb/cp_redeemlog.20081109093448.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_redeemlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_redeemlog.743.sql
Added : /trunk/data/schemas/charmapdb/cp_xferlog.20080928225124.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_xferlog.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_xferlog.497.sql
Added : /trunk/data/schemas/charmapdb/cp_xferlog.20081109093448.sql (Copy from path: /trunk/data/schemas/charmapdb/cp_xferlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/charmapdb/cp_xferlog.743.sql
Added : /trunk/data/schemas/logindb/cp_banlog.20080928225124.sql (Copy from path: /trunk/data/schemas/logindb/cp_banlog.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_banlog.497.sql
Added : /trunk/data/schemas/logindb/cp_banlog.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_banlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_banlog.743.sql
Added : /trunk/data/schemas/logindb/cp_createlog.20080928225124.sql (Copy from path: /trunk/data/schemas/logindb/cp_createlog.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_createlog.497.sql
Added : /trunk/data/schemas/logindb/cp_createlog.20081012100127.sql (Copy from path: /trunk/data/schemas/logindb/cp_createlog.602.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_createlog.602.sql
Added : /trunk/data/schemas/logindb/cp_createlog.20081012100128.sql (Copy from path: /trunk/data/schemas/logindb/cp_createlog.609.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_createlog.609.sql
Added : /trunk/data/schemas/logindb/cp_createlog.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_createlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_createlog.743.sql
Added : /trunk/data/schemas/logindb/cp_credits.20080928225124.sql (Copy from path: /trunk/data/schemas/logindb/cp_credits.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_credits.497.sql
Added : /trunk/data/schemas/logindb/cp_credits.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_credits.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_credits.743.sql
Added : /trunk/data/schemas/logindb/cp_emailchange.20081103093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_emailchange.717.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_emailchange.717.sql
Added : /trunk/data/schemas/logindb/cp_emailchange.20081104093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_emailchange.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_emailchange.743.sql
Deleted : /trunk/data/schemas/logindb/cp_ipbanlog.1080.sql
Added : /trunk/data/schemas/logindb/cp_ipbanlog.20120816150540.sql (Copy from path: /trunk/data/schemas/logindb/cp_ipbanlog.1080.sql, Revision, 1161)
Added : /trunk/data/schemas/logindb/cp_loginlog.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_loginlog.727.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_loginlog.727.sql
Added : /trunk/data/schemas/logindb/cp_loginlog.20081109093449.sql (Copy from path: /trunk/data/schemas/logindb/cp_loginlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_loginlog.743.sql
Added : /trunk/data/schemas/logindb/cp_loginprefs.20080929191525.sql (Copy from path: /trunk/data/schemas/logindb/cp_loginprefs.522.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_loginprefs.522.sql
Added : /trunk/data/schemas/logindb/cp_loginprefs.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_loginprefs.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_loginprefs.743.sql
Added : /trunk/data/schemas/logindb/cp_pwchange.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_pwchange.741.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_pwchange.741.sql
Added : /trunk/data/schemas/logindb/cp_pwchange.20081109093449.sql (Copy from path: /trunk/data/schemas/logindb/cp_pwchange.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_pwchange.743.sql
Added : /trunk/data/schemas/logindb/cp_resetpass.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_resetpass.713.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_resetpass.713.sql
Added : /trunk/data/schemas/logindb/cp_resetpass.20081109093449.sql (Copy from path: /trunk/data/schemas/logindb/cp_resetpass.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_resetpass.743.sql
Added : /trunk/data/schemas/logindb/cp_trusted.20080928225124.sql (Copy from path: /trunk/data/schemas/logindb/cp_trusted.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_trusted.497.sql
Added : /trunk/data/schemas/logindb/cp_trusted.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_trusted.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_trusted.743.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20080928225124.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.497.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.497.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20081109093448.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.743.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.743.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20081109093449.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.780.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.780.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20081109093450.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.789.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.789.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20081109093451.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.790.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.790.sql
Added : /trunk/data/schemas/logindb/cp_txnlog.20081109093452.sql (Copy from path: /trunk/data/schemas/logindb/cp_txnlog.791.sql, Revision, 1161)
Deleted : /trunk/data/schemas/logindb/cp_txnlog.791.sql
Modified : /trunk/themes/installer/header.php
Modified : /trunk/themes/installer/install/index.php

February 26, 2013

Thanks for the answer

February 26, 2013

Why the charlog_db is missing again in the sql files . I know there is a post marked as solved ,http://rathena.org/board/topic/71045-how-to-fix-this-missing-char-log-sql/

but is missing in the current SVN. Is somebody still use the DB to record any character creation and deletion or I am the only one ?

February 26, 2013

I show in my Database and i got these Table. If you delete this table here the SQL Dump.

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cp_redeemlog
-- ----------------------------
DROP TABLE IF EXISTS `cp_redeemlog`;
CREATE TABLE `cp_redeemlog` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nameid` int(11) unsigned NOT NULL DEFAULT '0',
  `quantity` int(11) unsigned NOT NULL DEFAULT '0',
  `cost` int(11) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(11) unsigned DEFAULT NULL,
  `redeemed` tinyint(1) unsigned NOT NULL,
  `redemption_date` datetime DEFAULT NULL,
  `purchase_date` datetime NOT NULL,
  `credits_before` int(10) NOT NULL,
  `credits_after` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `nameid` (`nameid`,`account_id`,`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Log of redeemed donation items.';

-- ----------------------------
-- Records 
-- ----------------------------

February 20, 2013

the first Client who use lua files for item is 2012-04-18 . Client 2012-04-10 use "idnum2item....txt" for item's

February 19, 2013

i have follow this link http://z15.invisionfree.com/ROGuide/index.php?showtopic=9 to make a JobMount Clip

But ingame it shows at an apple without a description. Where do I have to enter the item name and description ?

idnum2itemdesctable.txt :

31111#
This JobMount change his look whenever you change your Job
#

idnum2itemdisplaynametable.txt:

// Custom Item
31111#JobMount_Clip#

item_db2.txt

31111,MountClip,MountClip,5,30000,,100,,0,,1,0xFFFFFFFF,7,2,136,,0,0,0,{ bonus bSpeedRate,25; },{ setoption Option_Misc_Ride,1; },{ setoption Option_Misc_Ride,0; }

Sign In

ParSalian

Posts

Joined

Last visited

Content Type

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by ParSalian

Install Error by Xantara FluxCP SVN 1162

Install Error by Xantara FluxCP SVN 1162

Install Error by Xantara FluxCP SVN 1162

Install Error by Xantara FluxCP SVN 1162

Whats happend to the charlog_db ?

Whats happend to the charlog_db ?

MySQL Error

Adding Custom Items (wiki didn't help me much no the search ^^, help)

Item name appears as "unknown" ,Item description not appears

Docs

Get Started

Github

Community

My Account