UBER CMS HELP
- Thread starter Gravy
- Start date
sumo
The end is nigh.
- Jan 18, 2014
- 143
- 102
When he tries to do that, it gives him an error. Saying that column can't have a default value.
sumo
The end is nigh.
- Jan 18, 2014
- 143
- 102
Okay, so, I just tried deleting the column and it did infact give me an emulator error, but I did say create a backup.
JayC
Always Learning
- Aug 8, 2013
- 5,504
- 1,401
@HarkRetros you are an idiot @Janzeer you were right.
Okay go into your SQL you used for your database and find the structure for your users table and just run the query to add the table column back into your users table.. Should be something like:
ALTER TABLE `users` ADD `acc_pornbanned`;
but it will give it a value type, so don't run that because it won't work lmao.
Okay and after you add that column back in open your design table to do this open navicat and just right click on the users table and click design
Scroll down to find acc_pornbanned and just set default value to 0
Image Help:
Edit :
Run this SQL after fixing please:
UPDATE `users` SET acc_pornbanned = 0;
Okay go into your SQL you used for your database and find the structure for your users table and just run the query to add the table column back into your users table.. Should be something like:
ALTER TABLE `users` ADD `acc_pornbanned`;
but it will give it a value type, so don't run that because it won't work lmao.
Okay and after you add that column back in open your design table to do this open navicat and just right click on the users table and click design
Scroll down to find acc_pornbanned and just set default value to 0
Image Help:
Edit :
Run this SQL after fixing please:
UPDATE `users` SET acc_pornbanned = 0;
- Thread starter
- #14
Yes, but my emulator doesnt show logs of me connecting. Scratch that i dont believe it is.
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>{hotelName} - Client</title>
<link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/client.css" type="text/css">
<script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/swfobject.js"></script>
<script type="text/javascript">
var BaseUrl = "{swf_folder}";
var flashvars =
{
"client.starting" : "Please wait, {hotelName} is loading",
"client.allow.cross.domain" : "1",
"client.notify.cross.domain" : "0",
"connection.info.host" : "{server_ip}",
"connection.info.port" : "{server_port}",
"site.url" : "{url}",
"url.prefix" : "{url}",
"client.reload.url" : "{url}/client",
"client.fatal.error.url" : "{url}/me",
"client.connection.failed.url" : "{url}/me",
"external.variables.txt" : "{external_vars}",
"external.texts.txt" : "{external_texts}",
"productdata.load.url" : "{product_data}",
"furnidata.load.url" : "{furni_data}",
"use.sso.ticket" : "1",
"sso.ticket" : "<?php mysql_query("SHOW Auth_ticket FROM users") ?>",
"processlog.enabled" : "0",
"flash.client.url" : BaseUrl,
"flash.client.origin" : "popup"
};
var params =
{
"base" : BaseUrl + "/",
"allowScriptAccess" : "always",
"menu" : "false"
};
swfobject.embedSWF(BaseUrl + "/Habbo.swf", "client", "100%", "100%", "10.0.0", "{swf_folder}/expressInstall.swf", flashvars, params, null);
</script>
</head>
<body>
<div id="client"></div>
</body>
</html>
Last edited:
Khalil
IDK
- Dec 6, 2011
- 1,642
- 786
Idiots..
JayCustom is the only on this thread if not the only one around the habbo help section who replies with actual help. However, a future advice, instead of going through all that hustle, you can just run a three line query, like so:
JayCustom is the only on this thread if not the only one around the habbo help section who replies with actual help. However, a future advice, instead of going through all that hustle, you can just run a three line query, like so:
Code:
ALTER TABLE `users`
DROP COLUMN `acc_pornbanned`,
ADD COLUMN `acc_pornbanned` VARCHAR(60) NOT NULL DEFAULT '0';JayC
Always Learning
- Aug 8, 2013
- 5,504
- 1,401
Thank I wasn't sure how to add a column off the top of my head so I just told him to put it back, but yes this should fix your problem<-
Also:
You want to set all of the values already in the table to 0 I put the query already in this post
