[SOLVED] Xantara's FluxCP - Registering Error (Uh oh, what happened?)

[Xephyras]

Due to Brynner's help, I got my FluxCP running.

However, now I'm getting the famous 'Uh oh, what happened?' error when trying to register an account.

What is installed:

- I am using Xantara's FluxCP-rA (because Calciumkid's FluxCP gave unexisting errors).

- The FluxCP is running on the same system as the SQL server

- The FluxCP is the latest downloadable SVN from https://github.com/m...ntara/FluxCP-rA

- The rAthena SVN is Rev. 16622

What I can do on FluxCP:

- Basically everything (the server status is showing correctly, who is online is showing correctly etc.)

What I cannot do on FluxCP:

- Just registering a new account

I have read a lot of topics about this error, for example, about if the group_id and birthday columns are present at login table, if the username/password is correct, if the hostname/port is correct etc. and I have re-checked them all and confirmed that they are correct (else I wouldn't be able to install FluxCP and get it running, I presume).

There is only one thing that bothers me, might it be that Xantara's FluxCP-rA doesn't have the 'group_id' and is using 'level' instead? Or does the problem come from somewhere else? Also, does the RO server needs to be up in order to be able to register? (because it's currently down)

Please help, and thanks in advance!

Edited August 18, 2012 by Xephyras

[Brynner]

check your configuration?

Edited August 14, 2012 by Brynner

[Xephyras]

Well, I already did that, and a lot of times too at any configuration possible.

Unless you could tell me specifically which config I should look into again.

[Brynner]

before you use calciumkid fluxcp?then now you use xantara fluxcp?did you check the configuration of your sql?did you drop the old sql stored at your database?before you reinstall the xantara fluxcp?

[Xephyras]

Yes, I deleted the whole system and all the related folders, I even did a format on the system that the FluxCP is running at and re-installed everything again accordingly with the new Xantara's FluxCP-rA only.

[Brynner]

hmmm i use xantara fluxcp but i don't get that error. also it has group_id.

[Xephyras]

Would it be possible if you could post your application.php and server.php configurations or any related configuration?

(of course, exclude the password and username)

[Brynner]

hmmm your main.sql that you use is the rathena sql files?maybe the problem is on sql.

[Xephyras]

I am using rAthena Rev16622 main.sql, yes.

Maybe if I could check someone who had it working configuration files, I could get it to work.

I thought that my files were messed up, so I downloaded the FluxCP files many times over and over (which did the trick with rAthena), but still no progress.

Edited August 14, 2012 by Xephyras

[Xantara]

Hmm... If you are sure your ragnarok database that you configured in servers.php has the birthdate and group_id column, please check if there are any SQL error (file) outputs in the cp/data/logs/mysql/errors/ folder. If there is, please post. You can also try checking cp/data/logs/errors/exceptions/ folder.

EDIT: Sorry, having troubles posting on rAthena right now and it is late where I live.. I might not be able to respond til tomorrow (when I wake up), but I hope you are able to find a solution before then ^^;

[Xephyras]

@Xantara

I just checked my servers.php and I didn't find anything near 'birthday'.

I'll just post my servers.php and application.php here:

servers.php:

<?php
return array(
// Example server configuration. You may have more arrays like this one to
// specify multiple server groups (however they should share the same login
// server whilst they are allowed to have multiple char/map pairs).
array(
 'ServerName'	 => 'FluxRO',
 // Global database configuration (excludes logs database configuration).
 'DbConfig'	   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  'Encoding'   => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'FluxCP',
  'Password'   => '111111',
  'Database'   => 'ragnarokmain',
  'Persistent' => true,
  'Timezone'   => null // Example: '+0:00' is UTC.
  // The possible values of 'Timezone' is as documented from the MySQL website:
  // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
  // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
  // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
 ),
 // This is kept separate because many people choose to have their logs
 // database accessible under different credentials, and often on a
 // different server entirely to ensure the reliability of the log data.
 'LogsDbConfig'   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  'Encoding'   => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'FluxCP',
  'Password'   => '111111',
  'Database'   => 'ragnaroklog',
  'Persistent' => true,
  'Timezone'   => null // Possible values is as described in the comment in DbConfig.
 ),
 // Login server configuration.
 'LoginServer'	=> array(
  'Address'  => '127.0.0.1',
  'Port'	 => 6900,
  'UseMD5'   => true,
  'NoCase'   => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
  'GroupID'  => 0,	// Default account group ID during registration.
  //'Database' => 'ragnarok'
 ),
 'CharMapServers' => array(
  array(
'ServerName'	=> 'FluxRO',
'BaseExpRates'  => 200,
'JobExpRates'   => 200,
'MvpExpRates'   => 200,
'DropRates'	 => 25,
'MvpDropRates'  => 25,
'CardDropRates' => 25,
'MaxCharSlots'  => 9,
'Renewal'	   => true,
'DateTimezone'  => null,	   // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
//'ResetDenyMaps' => 'sec_pri',  // Defaults to 'sec_pri'. This value can be an array of map names.
//'Database'	  => 'ragnarok', // Defaults to DbConfig.Database
'CharServer'	=> array(
 'Address'   => '127.0.0.1',
 'Port'	  => 6121
),
'MapServer'	 => array(
 'Address'   => '127.0.0.1',
 'Port'	  => 5121
),
// -- WoE days and times --
// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
// Second parameter: Starting hour in 24-hr format.
// Third paramter: Ending day (possible value is same as starting day).
// Fourth (final) parameter: Ending hour in 24-hr format.
// ** (Note, invalid times are ignored silently.)
'WoeDayTimes'   => array(
 //array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
 //array(3, '14:00', 3, '15:00')  // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
),
// Modules and/or actions to disallow access to during WoE.
'WoeDisallow'   => array(
 array('module' => 'character', 'action' => 'online'),  // Disallow access to "Who's Online" page during WoE.
 array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
)
  )
 )
)
);
?>

application.php:

<?php
// This is the application configuration file. All values have been set to
// the default, and should be changed as needed.
return array(
'ServerAddress'		=> 'localhost',			  // This value is the hostname:port under which Flux runs. (e.g., example.com or example.com:80)
'BaseURI'			  => '',					   // The base URI is the base web root on which your application lies.
'InstallerPassword'	=> 'fluxtest',		 // Installer/updater password.
'RequireOwnership'	 => true,					 // Require the executing user to be owner of the FLUX_ROOT/data/ directory tree? (Better for security)
												 // WARNING: This will be mostly IGNORED on non-POSIX-compliant OSes (e.g. Windows).
'DefaultLoginGroup'	=> null,
'DefaultCharMapServer' => null,
'DefaultLanguage'	  => 'en_us',				  // Specify the default control panel language (see FLUX_ROOT/lang/ directory for available languages.)
'SiteTitle'			=> 'Flux Control Panel',	 // This value is only used if the theme decides to use it.
'ThemeName'			=> 'default',				// The theme name of the theme you would like to use.  Themes are in FLUX_ROOT/themes.
'ScriptTimeLimit'	  => 0,						// Script execution time limit. Specifies (in seconds) how long a page should run before timing out. (0 means forever)
'MissingEmblemBMP'	 => 'empty.bmp',			  //
'ItemIconNameFormat'   => '%d.gif',				 // The filename format for item icons (defaults to {itemid}.gif).
'ItemImageNameFormat'  => '%d.png',				 // The filename format for item images (defaults to {itemid}.png).
'MonsterImageNameFormat' => '%d.gif',			   // The filename format for monster images (defaults to {monsterid}.gif).
'ForceEmptyEmblem'	 => false,					// Forcefully display empty guild emblems, helpful when you don't have GD2 installed.
'EmblemCacheInterval'  => 12,					   // Hourly interval to re-cache guild emblems (set to 0 to disable emblem cache).
'SessionCookieExpire'  => 48,					   // Duration in hours.
'AdminMenuGroupLevel'  => AccountLevel::LOWGM,	  // The starting group ID for which module actions are moved into the admin menu for display.
'DateDefaultTimezone'  => null,					 // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ)
'DateFormat'		   => 'Y-m-d',				  // Default DATE format to be displayed in pages.
'DateTimeFormat'	   => 'Y-m-d H:i:s',			// Default DATETIME format to be displayed in pages.
'ShowSinglePage'	   => true,					 // Whether or not to show the page numbers even if there's only one page.
'ResultsPerPage'	   => 20,					   // The number of results to display in a paged set, per page.
'PagesToShow'		  => 10,					   // The number of page numbers to display at once.
'PageJumpMinimumPages' => 1,						// Minimum number of required pages before page jump box is shown. (0 to always show!)
'ShowPageJump'		 => true,					 // Whether or not to show the "Page Jump" box.
'SingleMatchRedirect'  => true,					 // Whether or not to redirect to view action from index page if only one match is returned (and action is allowed).
'SingleMatchRedirectItem' => false,				 // Same as above, for item module.
'SingleMatchRedirectMobs' => false,				 // Same as above, for monster module.
'UsernameAllowedChars' => 'a-zA-Z0-9_',			 // PCRE Format Pattern. default: 'a-zA-Z0-9_' (alphanumeric and underscore)
													// WARNING: This string isn't escaped so be careful which chars you use!
													// PCRE Pattern Ref: http://php.net/manual/en/pcre.pattern.php
'MinUsernameLength'	=> 4,						// Minimum username length.
'MaxUsernameLength'	=> 23,					   // Maximum username length.
'MinPasswordLength'	=> 8,						// Minimum password length.
'MaxPasswordLength'	=> 31,					   // Maximum password length.
'PasswordMinUpper'	 => 1,						// Number of upper-case letters to require in passwords.
'PasswordMinLower'	 => 1,						// Number of lower-case letters to require in passwords.
'PasswordMinNumber'	=> 1,						// Number of numbers to require in passwords.
'PasswordMinSymbol'	=> 0,						// Number of symbols to require in passwords.
'GMMinPasswordLength'  => 8,						// Minimum password length for GM accounts.
'GMPasswordMinUpper'   => 1,						// Number of upper-case letters to require in passwords for GM accounts.
'GMPasswordMinLower'   => 1,						// Number of lower-case letters to require in passwords for GM accounts.
'GMPasswordMinNumber'  => 1,						// Number of numbers to require in passwords for GM accounts.
'GMPasswordMinSymbol'  => 1,						// Number of symbols to require in passwords for GM accounts.
'RandomPasswordLength' => 16,					   // This is the length of the random password generated by the "Reset Password" feature. (NOTE: Hardcoded minimum value of 8)
'AllowUserInPassword'  => false,					// Whether or not to allow the password to contain the username. (NOTE: A case-insensitive search is performed)
'AllowDuplicateEmails' => false,					// Whether or not to allow duplicate e-mails to be used in registration. (See Mailer config options)
'RequireEmailConfirm'  => false,					// Require e-mail confirmation during registration.
'RequireChangeConfirm' => false,					// Require confirmation when changing e-mail addresses.
'EmailConfirmExpire'   => 48,					   // E-mail confirmations expire hours. Unconfirmed accounts will expire after this period of time.
'MailerFromAddress'	=> 'noreply@localhost',	  // The e-mail address displayed in the From field.
'MailerFromName'	   => 'MailerName',			 // The name displayed with the From e-mail address.
'MailerUseSMTP'		=> false,					// Whether or not to use a separate SMTP server for sending mail.
'MailerSMTPUseSSL'	 => false,					// Whether or not mailer should connect using SSL (yes for GMail).
'MailerSMTPUseTLS'	 => false,					// Same as above SSL setting, but for TLS.  This setting will override the SSL setting.
'MailerSMTPPort'	   => null,					 // When MailerUseSMTP is true: SMTP server port (mailer will default to 25).
'MailerSMTPHosts'	  => null,					 // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')).
'MailerSMTPUsername'   => null,					 // When MailerUseSMTP is true: Authorized username for SMTP server.
'MailerSMTPPassword'   => null,					 // When MailerUseSMTP is true: Authorized password for SMTP server (for above user).
'ServerStatusCache'	=> 2,						// Store a cached server status and refresh every X minutes.  Default: 2 minutes (value is measured in minutes).
'ServerStatusTimeout'  => 2,						// For each server, spend X amount of seconds to determine whether it's up or not.
'SessionKey'		   => 'fluxSessionData',		// Shouldn't be changed, just specifies the session key to be used for session data.
'DefaultModule'		=> 'main',				   // This is the module to execute when none has been specified.
'DefaultAction'		=> 'index',				  // This is the default action for any module, probably should leave this alone. (Deprecated)
'GzipCompressOutput'   => false,					// Whether or not to compress output using zlib.
'GzipCompressionLevel' => 9,						// zlib compression level. (1~9)
'OutputCleanHTML'	  => true,					 // Use this if you have Tidy installed to clean your HTML output when serving pages.
'ShowCopyright'		=> true,					 // Whether or not to show the copyright footer.
'ShowRenderDetails'	=> true,					 // Shows the "page rendered in X seconds" and "number of queries executed: X" in the default theme.
'UseCleanUrls'		 => false,					// Set to true if you're running Apache and it supports mod_rewrite and .htaccess files.
'DebugMode'			=> true,					// Set to false to minimize technical details from being output by Flux. WARNING: DO NOT USE THIS OPTION ON A PUBLICALLY-ACCESSIBLE CP.
'UseCaptcha'		   => true,					 // Use CAPTCHA image for account registration to prevent automated account creations. (Requires GD2/FreeType2)
'UseLoginCaptcha'	  => false,					// Use CAPTCHA image for account logins. (Requires GD2/FreeType2)
'EnableReCaptcha'	  => false,					// Enables the use of reCAPTCHA instead of Flux's native GD2 library (http://www.google.com/recaptcha)
'ReCaptchaPublicKey'   => '...',					// This is your reCAPTCHA public key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaPrivateKey'  => '...',					// This is your reCAPTCHA private key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaTheme'	   => 'white',				  // ReCaptcha theme to use (see: http://code.google.com/apis/recaptcha/docs/customization.html#Standard_Themes)
'DisplaySinglePages'   => true,					 // Whether or not to display paging for single page results.
'ForwardYears'		 => 15,					   // (Visual) The number of years to display ahead of the current year in date inputs.
'BackwardYears'		=> 30,					   // (Visual) The number of years to display behind the current year in date inputs.
'ColumnSortAscending'  => ' ▲',					 // (Visual) Text displayed for ascending sorted column names.
'ColumnSortDescending' => ' ▼',					 // (Visual) Text displayed for descending sorted column names.
'CreditExchangeRate'   => 1.0,					  // The rate at which credits are exchanged for dollars.
'MinDonationAmount'	=> 2.0,					  // Minimum donation amount. (NOTE: Actual donations made that are less than this account won't be exchanged)
'DonationCurrency'	 => 'USD',					// Preferred donation currency. Only donations made in this currency will be processed for credit deposits.
'MoneyDecimalPlaces'   => 2,						// (Visual) Number of decimal places to display in amount.
'MoneyThousandsSymbol' => ',',					  // (Visual) Thousandths place separator (a period in European currencies).
'MoneyDecimalSymbol'   => '.',					  // (Visual) Decimal separator (a comma in European currencies).
'AcceptDonations'	  => true,					 // Whether or not to accept donations.
'PayPalIpnUrl'		 => 'www.sandbox.paypal.com', // The URL for PayPal's IPN responses (www.paypal.com for live and www.sandbox.paypal.com for testing)
'PayPalBusinessEmail'  => 'admin@localhost',		// Enter the e-mail under which you have registered your business account.
'PayPalReceiverEmails' => array(					// These are the receiver e-mail addresses who are allowed to receive payment.
 //'admin2@localhost',							 // -- This array may be empty if you only use one e-mail
 //'admin3@localhost'							  // -- because your Business Email is also checked.
),
'GStorageLeaderOnly'   => false,					// Only allow guild leader to view guild storage rather than all members?
'DivorceKeepChild'	 => false,					// Keep child after divorce?
'DivorceKeepRings'	 => false,					// Keep wedding rings after divorce?
'IpWhitelistPattern'   =>						   // PCRE Format Pattern. It's recommended you add your gameserver, webserver and server owner's IPs here.
 '(127\.0\.0\.1|0(\.[0\*]){3})',				 // WARNING: This string isn't escaped so be careful which chars you use!
											  // By default, whitelists 127.0.0.1 (localhost) and 0.0.0.0 (all interfaces; whitelists all wildcard bans that can achive this too)
'AllowIpBanLogin'	  => false,					// Allow logging into account from banned IP.
'AllowTempBanLogin'	=> false,					// Allow logging in of temporarily banned accounts.
'AllowPermBanLogin'	=> false,					// Allow logging in of permanently banned accounts.
'AutoRemoveTempBans'   => true,					 // Automatically remove expired temporary bans on certain pages.
'ItemShopMaxCost'	  => 99,					   // Max price an item can be sold for.
'ItemShopMaxQuantity'  => 99,					   // Max quantity the item may be sold at once for.
'HideFromWhosOnline'   => AccountLevel::LOWGM,	  // Levels greater than or equal to this will be hidden from the "Who's Online" page.
'HideFromMapStats'	 => AccountLevel::LOWGM,	  // Levels greater than or equal to this will be hidden from the "Map Stats" page.
'EnableGMPassSecurity' => AccountLevel::LOWGM,	  // Levels greater than or equal to this will be required to use passwords that meet the earlier GM Password settings.
'ChargeGenderChange'   => 0,						// You can specify this as the number of credits to charge for gender change.  Can be 0 for free change.
'BanPaymentStatuses'   => array(					// Payment statuses that will automatically ban the account owner if received.
 'Cancelled_Reversal',						   // -- 'Cancelled_Reversal'
 'Reversed',									 // -- 'Reversed'
),

'HoldUntrustedAccount' => 0,						// This is the time in hours to hold a donation crediting process for, if the account
												 // isn't a trusted account. Specify 0 or false to disable this feature.

'AutoUnholdAccount'	=> false,					// Enable this to auto-unhold an account and credit it if the transaction is still
												 // valid.  This only applies if you are using the HoldUnstrustedAccount feature.
												 // If you want to run a cron job instead, you can make a request to the '/donate/update'
												 // module/action with the InstallerPassword as the password to run the update task.
												 // With clean URLs: http://<server>/<baseURI>/donate/update?password=<InstallerPassword>
												 // Without clean URLs: http://<server>/<baseURI>?module=donate&action=update&password=<InstallerPassword>
												 // NOTE: This option is HIGHLY inefficient, it's recommended to run a cron job instead.

'AutoPruneAccounts'	=> false,					// Enable this to automatically prune expired accounts. Enabling this is a performance
												 // performance killer. See 'AutoUnholdAccount' for running this task as a cron job,
											  // the module is 'account' and the action is 'prune'.
												 // With clean URLs: http://<server>/<baseURI>/account/prune?password=<InstallerPassword>
												 // Without clean URLs: http://<server>/<baseURI>?module=account&action=prune&password=<InstallerPassword>

'ShopImageExtensions'  => array(					// These are the image extensions allowed for uploading in the item shop.
 'png', 'jpg', 'gif', 'bmp', 'jpeg'
),
'NoResetPassGroupLevel'  => AccountLevel::LOWGM,	// Minimum group level of account to prevent password reset using control panel.

'CharRankingLimit'	   => 20,					 //
'GuildRankingLimit'	  => 20,					 //
'ZenyRankingLimit'	   => 20,					 //
'DeathRankingLimit'	  => 20,					 //
'RankingHideGroupLevel'  => AccountLevel::LOWGM,	//
'InfoHideZenyGroupLevel' => AccountLevel::LOWGM,	// Minimum group level of account to hide zeny from in server information page.

'CharRankingThreshold'  => 0,					   // Number of days the character must have logged in within to be listed in character ranking. (0 = disabled)
'ZenyRankingThreshold'  => 0,					   // Number of days the character must have logged in within to be listed in zeny ranking. (0 = disabled)
'DeathRankingThreshold' => 0,					   // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)

'HideTempBannedCharRank'  => false,				 // Hide temporarily banned characters from ranking.
'HidePermBannedCharRank'  => true,				  // Hide permanently banned characters from ranking.

'HideTempBannedZenyRank'  => false,				 // Hide temporarily banned characters from ranking.
'HidePermBannedZenyRank'  => true,				  // Hide permanently banned characters from ranking.

'HideTempBannedDeathRank' => false,				 // Hide temporarily banned characters from ranking.
'HidePermBannedDeathRank' => true,				  // Hide permanently banned characters from ranking.

'HideTempBannedStats'	 => false,				 // Hide temporarily banned accounts from statistics.
'HidePermBannedStats'	 => true,				  // Hide permanently banned accounts from statistics.

'SortJobsByAmount'		=> false,				 // Sort job class information on statistics page by descending quantity (false = Sort by Job ID).

'CpLoginLogShowPassword'  => false,				 // Show password in CP login log (also see access.php's SeeCpLoginLogPass).

'CpResetLogShowPassword'  => false,				 // Show password in CP "password resets" log (also see access.php's SeeCpResetPass).

'CpChangeLogShowPassword' => false,				 // Show password in CP "password changes" log (also see access.php's SeeCpChangePass).

'AdminMenuNewStyle'	   => true,				  // Use new-style admin menu;  Applies to 'default' theme.

// These are the main menu items that should be displayed by themes.
// They route to modules and actions.  Whether they are displayed or
// not at any given time depends on the user's account group level and/or
// their login status.
'MenuItems' => array(
 'Main Menu'   => array(
  'Home'		  => array('module' => 'main'),
  //'Forums'		=> array('exturl' => 'http://www.fluxro.com/community'),
 ),
 'Account'	 => array(
  'Register'	  => array('module' => 'account', 'action' => 'create'),
  'Login'		 => array('module' => 'account', 'action' => 'login'),
  'Logout'		=> array('module' => 'account', 'action' => 'logout'),
  'History'	   => array('module' => 'history'),
  'My Account'	=> array('module' => 'account', 'action' => 'view'),
 ),
 'Donations'   => array(
  'Purchase'	  => array('module' => 'purchase'),
  'Donate'		=> array('module' => 'donate'),
 ),
 'Information' => array(
  'Server Info.'  => array('module' => 'server', 'action' => 'info'),
  'Server Status' => array('module' => 'server', 'action' => 'status'),
  'WoE Hours'	 => array('module' => 'woe'),
  'Castles'	   => array('module' => 'castle'),
  "Who's Online"  => array('module' => 'character', 'action' => 'online'),
  'Map Statistics'=> array('module' => 'character', 'action' => 'mapstats'),
  'Ranking Info.' => array('module' => 'ranking', 'action' => 'character'),
 ),
 'Database'	=> array(
  'Item Database' => array('module' => 'item'),
  'Mob Database'  => array('module' => 'monster'),
 ),
 'Misc. Stuff' => array(
  'rA Logs'	   => array('module' => 'logdata'),
  'CP Logs'	   => array('module' => 'cplog'),
  'IP Ban List'   => array('module' => 'ipban'),
  'Accounts'	  => array('module' => 'account'),
  'Characters'	=> array('module' => 'character'),
  'Guilds'		=> array('module' => 'guild'),
  'Send Mail'	 => array('module' => 'mail'),
  'Re-Install'	=> array('module' => 'install', 'action' => 'reinstall'),
  //'Auction'	   => array('module' => 'auction'),
  //'Economy'	   => array('module' => 'economy'),
 )
),

// Sub-menu items that are displayed for any action belonging to a
// particular module. The format it simple.
'SubMenuItems' => array(
 'history' => array(
  'gamelogin'  => 'Game Logins',
  'cplogin'	=> 'CP Logins',
  'emailchange'=> 'E-Mail Changes',
  'passchange' => 'Password Changes',
  'passreset'  => 'Password Resets'
 ),
 'account' => array(
  'index'	  => 'List Accounts',
  'view'	   => 'View Account',
  'changepass' => 'Change Password',
  'changemail' => 'Change E-mail',
  'changesex'  => 'Change Gender',
  'transfer'   => 'Transfer Credits',
  'xferlog'	=> 'Credit Transfer History',
  'cart'	   => 'Go to Shopping Cart',
  'login'	  => 'Login',
  'create'	 => 'Register',
  'resetpass'  => 'Reset Password',
  'resend'	 => 'Resend E-mail Confirmation'
 ),
 'guild' => array(
  'index'  => 'List Guilds',
  'export' => 'Export Guild Emblems'
 ),
 'server' => array(
  'status'	 => 'View Status',
  'status-xml' => 'View Status as XML'
 ),
 'logdata' => array(
  //'char'	=> 'Characters',
  //'inter'   => 'Interactions',
  'command' => 'Commands',
  //'branch'  => 'Branches',
  'chat'	=> 'Chat Messages',
  'login'   => 'Logins',
  //'mvp'	 => 'MVP',
  //'npc'	 => 'NPC',
  'pick'	=> 'Item Picks',
  'zeny'	=> 'Zeny'
 ),
 'cplog' => array(
  'paypal'	 => 'PayPal Transactions',
  'login'	  => 'Logins',
  'resetpass'  => 'Password Resets',
  'changepass' => 'Password Changes',
  'changemail' => 'E-mail Changes',
  'ban'		=> 'Account Bans',
  'ipban'	  => 'IP Bans'
 ),
 'purchase' => array(
  'index'	=> 'Shop',
  'cart'	 => 'Go to Cart',
  'checkout' => 'Checkout',
  'clear'	=> 'Empty Cart',
  'pending'  => 'Pending Redemption'
 ),
 'donate' => array(
  'index'   => 'Make a Donation',
  'history' => 'Donation History',
  'trusted' => 'Trusted PayPal E-mails'
 ),
 'ipban' => array(
  'index' => 'IP Ban List',
  'add'   => 'Add IP Ban'
 ),
 'ranking' => array(
  'character' => 'Character Ranking',
  'guild'	 => 'Guild Ranking',
  'zeny'	  => 'Zeny Ranking',
  'death'	 => 'Death Ranking'
 ),
 'item' => array(
  'index' => 'List Items',
  'add'   => 'Add Item'
 )
),

'AllowMD5PasswordSearch'	   => false,
'ReallyAllowMD5PasswordSearch' => false, // Are you POSITIVELY sure?

// Specifies which modules and actions should be ignored by Tidy
// (enabled/disabled by the OutputCleanHTML option).
'TidyIgnore' => array(
 array('module' => 'captcha'),
 array('module' => 'guild', 'action' => 'emblem')
),

// Job classes, loaded from another file to avoid cluttering this one.
// There isn't normally a need to modify this file, unless it's been
// modified in an update. (In English: DON'T TOUCH THIS.)
'JobClasses'	=> include('jobs.php'),

// Gender-linked Job class IDs and their corresponding names.
// Should be left alone unless new gender-specific job classes are introduced.
'GenderLinkedJobClasses' => include('jobs_gender_linked.php'),

// Homunculus class IDs and their corresponding names.
// Best not to mess with this either.
'HomunClasses' => include('homunculus.php'),
// Item Types with their corresponding names.
// Shouldn't touch this either.
'ItemTypes' => include('itemtypes.php'),

// Specil Item Types with their corresponding names (For Weapons & Ammo by default).
// Shouldn't touch this either.
'ItemTypes2' => include('itemtypes2.php'),

// Common Equip Location Combinations with their corresponding names.
// Shouldn't touch this unless you've added custom combinations.
'EquipLocationCombinations' => include('equip_location_combinations.php'),

// Error Code -> Error Type mapping.
// Shouldn't need touching, however modifying loginerrors.php should be relatively safe.
'LoginErrors' => include('loginerrors.php'),

// rA equip jobs mapping.
'EquipJobs' => include('equip_jobs.php'),

// rA equip locations mapping.
'EquipLocations' => include('equip_locations.php'),

// rA equip upper mapping.
'EquipUpper' => include('equip_upper.php'),

// rA monster sizes mapping.
'MonsterSizes' => include('sizes.php'),

// rA monster races mapping.
'MonsterRaces' => include('races.php'),

// rA elements mapping.
'Elements' => include('elements.php'),

// rA attributes mapping.
'Attributes' => include('attributes.php'),

// rA monster modes mapping.
'MonsterModes' => include('monstermode.php'),

// Item shop categories.
'ShopCategories' => include('shopcategories.php'),

// Item pick and zeny log types.
'PickTypes' => include('picktypes.php'),

// Castle names.
'CastleNames' => include('castlenames.php'),

// DON'T TOUCH. THIS IS FOR DEVELOPERS.
'FluxTables' => array(
 'CreditsTable'		=> 'cp_credits',
 'CreditTransferTable' => 'cp_xferlog',
 'ItemShopTable'	   => 'cp_itemshop',
 'TransactionTable'	=> 'cp_txnlog',
 'RedemptionTable'	 => 'cp_redeemlog',
 'AccountCreateTable'  => 'cp_createlog',
 'AccountBanTable'	 => 'cp_banlog',
 'IpBanTable'		  => 'cp_ipbanlog',
 'DonationTrustTable'  => 'cp_trusted',
 'AccountPrefsTable'   => 'cp_loginprefs',
 'CharacterPrefsTable' => 'cp_charprefs',
 'ResetPasswordTable'  => 'cp_resetpass',
 'ChangeEmailTable'	=> 'cp_emailchange',
 'LoginLogTable'	   => 'cp_loginlog',
 'ChangePasswordTable' => 'cp_pwchange'
)
);
?>

The following errors are given at cp/data/logs/mysql/errors/ folder:

[2012-08-14 13:06:24] [sqlSTATE=42000] Err 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 'Main.char WHERE online > 0' at line 1

[2012-08-14 13:06:52] [sqlSTATE=42000] Err 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 'Main.login WHERE LOWER(userid) = LOWER('Test') LIMIT 1' at line 1

[2012-08-14 13:06:52] [sqlSTATE=42000] Err 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 'Main.login WHERE email = '[email protected]' LIMIT 1' at line 1

[2012-08-14 13:06:52] [sqlSTATE=42000] Err 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 'Server Main.login (userid, user_pass, email, sex, group_id, birthdate) VALUES ('' at line 1

There were no errors given at cp/data/logs/errors/exceptions/, the folder was empty.

I hope this gives more detail in where it goes wrong.

[Brynner]

make sure that you execute the log.sql to this database name. ragnaroklog

[Xephyras]

@Brynner

I did that too, but no success.

I'm gonna list all the things I did, so maybe that could make you able to conclude what I missed.

I did the following in actual order:

- Setting up SQL server connection (localhost)

- Made account FluxCP (as described in my server.php)

- Gave user FluxCP all permissions to alter the SQL databases

- Made ragnarokmain database

- Made ragnaroklog database

- Executed all *.sql files from rAthena - Rev16622 on ragnarokmain database

- Executed log.sql from rAthena- Rev16622 on ragnaroklog database

- Altered login table from ragnarokmain database's username and password according to the username and password used in rAthena's login,char and map_conf.

- Downloaded Xantara's FluxCP

- Altered records in Xantara's FluxCP's application.php and server.php accordingly (see above post for results on application.php and server.php)

- Put the altered Xantara's FluxCP in Apache's HTML folder (everything related to Apache, including all php files, mysql, etc. are installed)

- Changed the owner of Apache's HTML folder to Apache (including FluxCP folder and files), instead of root.

- Changed the permission for Apache to read and write on FluxCP's folder and files.

- Went to the FluxCP address on I.E.8

- Installed and updated FluxCP

- Checked if everything worked (server status, who is online etc.)

- Tried to register a new account and failed (the error appeared)

[Brynner]

hmmm try to make 1 database? example. ragnarok. just put there all your database. main, log, item, mobs etc. then try to reinstall the fluxcp using its default database. like ragnarok. check if the problem is still there.

[Xephyras]

Well, I have literally tried everything including what you just suggesting Brynner.

I'm going to have a rest now, cuz I have been doing this the whole day already and am tired....

I hope I can solve it tomorrow with your guys' help.

[Brynner]

do you have a teamviewer?

[Xantara]

Hmm.. Well, the registering works fine for me..

From those logs, it looks like a bad database name setup/config, but your servers.php looks fine for me and I see no instance of 'Main' or 'Server Main' database name in there o_o

How did you install/update the CP? Did you click the "install or update all" link or did you enter your username and password in the webpage?

Perhaps try to delete the contents inside of the cp/data/tmp/ folder excluding the index.html file.

Please let me know how it goes. But, yes, TeamViewer may help fix things (faster). Good luck~

[Xephyras]

@Xantara

I didn't understand the 'Main' and 'Server Main' part of the error either. I never used those two names (or is it something that I SHOULD use instead?).

Also, I installed FluxCP with username and password. It doesn't allow me to install without it.

@Brynner

I am gonna reinstall the whole system again, with a better database naming and see if it works. Cuz now I did lots of things and changed lots of things and probably messed up the whole system again.

If it doesn't work I will come back here and install TeamViewer.

[Brynner]

if doesn't work teamviewer will help you to fix your problem

[Xephyras]

@Brynner

What does TeamViewer exactly do other than remote assistant?

[Brynner]

yah

[Xantara]

@Xantara

Also, I installed FluxCP with username and password. It doesn't allow me to install without it.

^ That part worries me... If that is the case, then the information you provided in servers.php is, most likely, incorrect.

Try to:

1. delete your current setup

2. re-upload the CP

3. update the configuration settings in servers.php and application.php

4. set $showExceptions to true in cp/config/error.php

5. set 'DebugMode' to true in cp/config/applications.php

6. navigate to your site, and click the "install or update all" link.

If it doesn't work, it should show an error report why it didn't. Please show what it says in full.

[Xephyras]

Installing with or without password?

[Xephyras]

I am totally clueless about what exactly happened, but I am very glad it is solved now.

What I did:

- Bought a second host

- Put the CP on the second host

- Made the configuration to connect to first host

- Renamed the databases without spaces and/or periods.

What I think the problem was, was probably the database naming, like Brynner mentioned a while ago. For some reason, it just messes up the system if you use spaces or periods or whatever that is not alphabetical or number. I am not sure and cannot confirm this theory, but just a thought to share with anyone that might encounter the same problem.