Bolt Cms 1.0 Help Me!

[Thanatos31]

help me

 

[HaboaHabbo]

im having same issue bud

 

[Legend]

Check and make sure that the information is going into the correct fields in your database.
But this isn't a help forum, so you'll more than likely get some heat for posting this here. Let me know if you need further help.

 

[SujoyDeb]

Run the following as a query in your database.
But as @Dalt said, you posted this in the wrong section. Next time post in the "Habbo Help & Support".

ALTER TABLE users ADD `youtube_embed` varchar(255) NOT NULL DEFAULT 'fRh_vgS2dFE';
ALTER TABLE users ADD `country` varchar(255) NOT NULL DEFAULT 'Unknown';
ALTER TABLE users ADD `age` varchar(255) NOT NULL;
ALTER TABLE users ADD `email_updates` varchar(255) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `validation_code` varchar(255) NOT NULL;
ALTER TABLE users ADD `role` varchar(255) NOT NULL DEFAULT 'User';
ALTER TABLE users ADD `home_visible` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `validated` int(1) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `housekeeping_pin` int(4) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `me_radio` varchar(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `noob` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `donated_times` int(3) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `donated_amount` int(6) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `biography` varchar(500) NOT NULL DEFAULT 'I havn\'t typed anything here yet! :)';
ALTER TABLE users ADD `header` varchar(100) NOT NULL DEFAULT 'Change me!';
ALTER TABLE users ADD `selfie` varchar(200) NOT NULL DEFAULT '%cdna%/img/profiles/default.png';
ALTER TABLE users ADD `language` varchar(2) NOT NULL DEFAULT 'EN';
ALTER TABLE users ADD `hidden` varchar(1) NOT NULL DEFAULT '0';

 

[iGlenn]

Run the following as a query in your database.
But as @Dalt said, you posted this in the wrong section. Next time post in the "Habbo Help & Support".

ALTER TABLE users ADD `youtube_embed` varchar(255) NOT NULL DEFAULT 'fRh_vgS2dFE';
ALTER TABLE users ADD `country` varchar(255) NOT NULL DEFAULT 'Unknown';
ALTER TABLE users ADD `age` varchar(255) NOT NULL;
ALTER TABLE users ADD `email_updates` varchar(255) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `validation_code` varchar(255) NOT NULL;
ALTER TABLE users ADD `role` varchar(255) NOT NULL DEFAULT 'User';
ALTER TABLE users ADD `home_visible` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `validated` int(1) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `housekeeping_pin` int(4) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `me_radio` varchar(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `noob` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `donated_times` int(3) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `donated_amount` int(6) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `biography` varchar(500) NOT NULL DEFAULT 'I havn\'t typed anything here yet! :)';
ALTER TABLE users ADD `header` varchar(100) NOT NULL DEFAULT 'Change me!';
ALTER TABLE users ADD `selfie` varchar(200) NOT NULL DEFAULT '%cdna%/img/profiles/default.png';
ALTER TABLE users ADD `language` varchar(2) NOT NULL DEFAULT 'EN';
ALTER TABLE users ADD `hidden` varchar(1) NOT NULL DEFAULT '0';

i ran all those queries before and still get the same

 

[SujoyDeb]

Run the following as a query in your database.

ALTER TABLE users ADD `youtube_embed` varchar(255) NOT NULL DEFAULT 'fRh_vgS2dFE';
ALTER TABLE users ADD `country` varchar(255) NOT NULL DEFAULT 'Unknown';
ALTER TABLE users ADD `age` varchar(255) NOT NULL;
ALTER TABLE users ADD `email_updates` varchar(255) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `validation_code` varchar(255) NOT NULL;
ALTER TABLE users ADD `role` varchar(255) NOT NULL DEFAULT 'User';
ALTER TABLE users ADD `home_visible` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `validated` int(1) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `housekeeping_pin` int(4) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `me_radio` varchar(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `noob` int(1) NOT NULL DEFAULT '1';
ALTER TABLE users ADD `donated_times` int(3) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `donated_amount` int(6) NOT NULL DEFAULT '0';
ALTER TABLE users ADD `biography` varchar(500) NOT NULL DEFAULT 'I havn\'t typed anything here yet! :)';
ALTER TABLE users ADD `header` varchar(100) NOT NULL DEFAULT 'Change me!';
ALTER TABLE users ADD `selfie` varchar(200) NOT NULL DEFAULT '%cdna%/img/profiles/default.png';
ALTER TABLE users ADD `language` varchar(2) NOT NULL DEFAULT 'EN';
ALTER TABLE users ADD `hidden` varchar(1) NOT NULL DEFAULT '0';

i ran all those queries before and still get the same

Here's another potential fix.

/*
Navicat MariaDB Data Transfer

Source Server : localhost_3306
Source Server Version : 100114
Source Host : localhost:3306
Source Database : peace

Target Server Type : MariaDB
Target Server Version : 100114
File Encoding : 65001

Date: 2016-06-08 22:50:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cms_clicks
-- ----------------------------
DROP TABLE IF EXISTS `cms_clicks`;
CREATE TABLE `cms_clicks` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`timestamp` varchar(100) NOT NULL,
`ip_addr` varchar(100) NOT NULL,
`where_from` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1705 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_hk_logs
-- ----------------------------
DROP TABLE IF EXISTS `cms_hk_logs`;
CREATE TABLE `cms_hk_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`data` text NOT NULL,
`username` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4538 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_logins
-- ----------------------------
DROP TABLE IF EXISTS `cms_logins`;
CREATE TABLE `cms_logins` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`result` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16518 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`author` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for cms_profile_snogs
-- ----------------------------
DROP TABLE IF EXISTS `cms_profile_snogs`;
CREATE TABLE `cms_profile_snogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`to_id` int(11) NOT NULL DEFAULT '0',
`from_id` int(11) NOT NULL DEFAULT '0',
`type` varchar(20) NOT NULL DEFAULT 'snog',
`message` varchar(250) NOT NULL DEFAULT '',
`time` varchar(100) NOT NULL DEFAULT '',
`seen` varchar(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=236 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_queries
-- ----------------------------
DROP TABLE IF EXISTS `cms_queries`;
CREATE TABLE `cms_queries` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`data` varchar(500) NOT NULL,
`time` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1478 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_referrals
-- ----------------------------
DROP TABLE IF EXISTS `cms_referrals`;
CREATE TABLE `cms_referrals` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`user` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_settings
-- ----------------------------
DROP TABLE IF EXISTS `cms_settings`;
CREATE TABLE `cms_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_key` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_shop_packs
-- ----------------------------
DROP TABLE IF EXISTS `cms_shop_packs`;
CREATE TABLE `cms_shop_packs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT 'Null',
`description` text NOT NULL,
`img` varchar(355) NOT NULL DEFAULT 'null',
`price` varchar(255) NOT NULL DEFAULT '0',
`currency` varchar(5) NOT NULL DEFAULT 'USD',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_shop_purchases
-- ----------------------------
DROP TABLE IF EXISTS `cms_shop_purchases`;
CREATE TABLE `cms_shop_purchases` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`img` varchar(255) NOT NULL,
`price` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL DEFAULT 'USD',
`date_given` varchar(255) NOT NULL,
`delivered` varchar(1) NOT NULL DEFAULT '0',
`user_id` varchar(11) NOT NULL,
`donation` varchar(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_stats
-- ----------------------------
DROP TABLE IF EXISTS `cms_stats`;
CREATE TABLE `cms_stats` (
`user_peak` int(4) NOT NULL DEFAULT '0',
`rooms_peak` int(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_values
-- ----------------------------
DROP TABLE IF EXISTS `cms_values`;
CREATE TABLE `cms_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`thrones` varchar(11) DEFAULT NULL,
`dinos` varchar(11) DEFAULT NULL,
`img` varchar(500) DEFAULT NULL,
`last_edited` varchar(400) DEFAULT NULL,
`last_points` int(11) DEFAULT NULL,
`last_thrones` varchar(11) DEFAULT NULL,
`last_dinos` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_votes
-- ----------------------------
DROP TABLE IF EXISTS `cms_votes`;
CREATE TABLE `cms_votes` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(150) NOT NULL,
`timestamp` varchar(150) NOT NULL,
`ip_addr` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=367 DEFAULT CHARSET=utf8;

 

[iGlenn]

Here's another potential fix.

youre literally giving us all the queries from the released thread that we tried mate....

 

[LeChris]

What database / emulator

 

[iGlenn]

What database / emulator

the cms is designed for plus

 

[LeChris]

the cms is designed for plus

Let me set it up, and see what happens. Hold

 

[iGlenn]

Let me set it up, and see what happens. Hold

alright

 

[LeChris]

Run this

ALTER TABLE users
ALTER COLUMN auth_ticket SET DEFAULT '-'

 

[MadMonsterMan]

Run this

ALTER TABLE users
ALTER COLUMN auth_ticket SET DEFAULT '-'

Still saying the same thing

 

[Rain]

PM me ur Teamviewer details, and I'll fix it haha

 

[Ramyroma]

Im literally having the same problem, any fix?

 

[Rain]

Im literally having the same problem, any fix?

>

PM me ur Teamviewer details, and I'll fix it haha

<

 

[Ramyroma]

figured it out, column age didnt have a default value