Topic: Serious thread regarding SQL database shiz (wall of text)
+Beebs !!2dE4HTCjq — 13 years ago #26,014
I'm attempting to setup a BBS using ATBBS software and when I upload the INSTALL.sql file to the database, it gives me this error:
I'm going to go ahead and assume you'll be needing to see the actual file I'm trying to upload in it's entirety, so I'll post it below (sorry for the massive dump, if it's not needed)
Any help/tips would be greatly appreciated.
#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 '(AI) NOT NULL,
`message` text NOT NULL,
`poster` text NOT NULL,
`time` int' at line 8
I'm going to go ahead and assume you'll be needing to see the actual file I'm trying to upload in it's entirety, so I'll post it below (sorry for the massive dump, if it's not needed)
--- Import this SQL file to install ATBBS.
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--- Create tables:
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `activity`
---
CREATE TABLE `activity` (
`uid` varchar(23) NOT NULL,
`time` int(10) NOT NULL,
`action_name` varchar(60) NOT NULL,
`action_id` int(10) NOT NULL,
PRIMARY KEY (`uid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `bullitens`
---
CREATE TABLE `bullitens` (
`no` int (11) auto_increment (AI) NOT NULL,
`message` text NOT NULL,
`poster` text NOT NULL,
`time` int(11) NOT NULL,
`date` text NOT NULL,
`uid` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`uid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `failed_postings`
---
CREATE TABLE `failed_postings` (
`uid` varchar(23) NOT NULL,
`time` int(10) NOT NULL,
`reason` text NOT NULL,
`headline` varchar(100) NOT NULL,
`body` text NOT NULL,
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `ignore_lists`
---
CREATE TABLE `ignore_lists` (
`uid` varchar(23) NOT NULL,
`ignored_phrases` text NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `images`
---
CREATE TABLE IF NOT EXISTS `images` (
`file_name` varchar(80) NOT NULL,
`md5` varchar(32) NOT NULL,
`topic_id` int(10) unsigned DEFAULT NULL,
`reply_id` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `reply_id` (`reply_id`),
UNIQUE KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `ip_bans`
---
CREATE TABLE `ip_bans` (
`ip_address` varchar(100) NOT NULL,
`filed` int(10) NOT NULL,
`expiry` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `last_actions`
---
CREATE TABLE `last_actions` (
`feature` varchar(30) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`feature`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `pages`
---
CREATE TABLE `pages` (
`id` int(6) unsigned NOT NULL auto_increment,
`url` varchar(100) NOT NULL,
`page_title` varchar(200) NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `pre_bulliten`
---
CREATE TABLE `pre_bulliten` (
`no` int (11) auto_increment (AI) NOT NULL,
`message` text NOT NULL,
`poster` text NOT NULL,
`time` int(11) NOT NULL,
`date` text NOT NULL,
`uid` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`uid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `replies`
---
CREATE TABLE `replies` (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) NOT NULL,
`poster_number` int(10) NOT NULL,
`author` varchar(23) character set latin1 NOT NULL,
`author_ip` varchar(100) character set latin1 NOT NULL,
`time` int(10) NOT NULL,
`body` text character set latin1 NOT NULL,
`edit_time` int(10) default NULL,
`edit_mod` tinyint(1) default NULL,
`sticky` int(11) NULL default = 0,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`,`author`,`author_ip`),
KEY `letter` (`poster_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `topics`
---
CREATE TABLE `topics` (
`id` int(11) unsigned NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL,
`author` varchar(23) character set latin1 collate latin1_spanish_ci NOT NULL,
`author_ip` varchar(100) character set latin1 NOT NULL,
`replies` int(10) NOT NULL,
`last_post` int(10) NOT NULL,
`visits` int(10) NOT NULL default '0',
`headline` varchar(100) character set latin1 NOT NULL,
`body` text character set latin1 NOT NULL,
`edit_time` int(10) default NULL,
`edit_mod` tinyint(1) default NULL,
`sticky` int(11) NULL default = 0,
PRIMARY KEY (`id`),
KEY `author` (`author`),
KEY `author_ip` (`author_ip`),
KEY `last_post` (`last_post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `trash`
---
CREATE TABLE `trash` (
`uid` varchar(23) NOT NULL,
`time` int(10) NOT NULL,
`headline` varchar(100) NOT NULL,
`body` text NOT NULL,
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `uid_bans`
---
CREATE TABLE `uid_bans` (
`uid` varchar(23) NOT NULL,
`filed` int(10) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `users`
---
CREATE TABLE `users` (
`uid` varchar(23) character set latin1 NOT NULL,
`password` varchar(32) character set latin1 NOT NULL,
`first_seen` int(10) NOT NULL,
`ip_address` varchar(100) character set latin1 NOT NULL,
PRIMARY KEY (`uid`),
KEY `first_seen` (`first_seen`),
KEY `ip_address` (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `user_settings`
---
CREATE TABLE `user_settings` (
`uid` varchar(23) character set latin1 NOT NULL,
`memorable_name` varchar(100) character set latin1 NOT NULL,
`memorable_password` varchar(100) character set latin1 NOT NULL,
`email` varchar(100) character set latin1 NOT NULL,
`spoiler_mode` tinyint(1) NOT NULL default '0',
`snippet_length` smallint(3) NOT NULL default '80',
`topics_mode` tinyint(1) NOT NULL,
`ostrich_mode` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `memorable_name` (`memorable_name`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--- ------------------------------------------------------------------------------------
---
--- Table structure for table `watchlists`
---
CREATE TABLE `watchlists` (
`uid` varchar(23) NOT NULL,
`topic_id` int(10) NOT NULL,
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--- ------------------------------------------------------------------------------------
--- Insert some needed rows
INSERT INTO `last_actions` (`feature`, `time`) VALUES
('last_bump', 0),
('last_topic', 0);
INSERT INTO `pages` (`id`, `url`, `page_title`, `content`) VALUES
(1, 'FAQ', 'Frequently Asked Questions', '====How do I edit the FAQ?====\nUse the [/CMS content manager].'),
(2, 'markup_syntax', 'Markup syntax', '[\r\n<thead>\r\n\r\n<th class="minimal">Output</th>\r\n<th>Input</th>\r\n|\r\n</thead>\r\n\r\n\r\n\r\n|Emphasis\r\n|<kbd>'Emphasis'</kbd>\r\n|\r\n\r\n\r\n|Strong emphasis\r\n|<kbd>'Strong emphasis'</kbd>\r\n|\r\n\r\n\r\n|Header
\r\n|<kbd>==Header==</kbd>\r\n|\r\n\r\n\r\n|> Quote\r\n|<kbd>> Quote</kbd>\r\n|\r\n\r\n\r\n\r\n|[<a href= Link" rel="nofollow">http://example.com/">Link] text</a>\r\n|<kbd>[http://example.com/ Link text]</kbd>\r\n|\r\n\r\n\r\n|> Block<br />> quote\r\n|<kbd>> Block<br />quote</kbd>\r\n|\r\n\r\n\r\n]');
Any help/tips would be greatly appreciated.
+quack — 13 years ago, 17 minutes later[T] [B] #307,944
seems like MySQL uses a different syntax for attribute constraints. either change the sql file to match mysql syntax or figure out which dbms the bbs was tested against and use that.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 3 minutes later, 20 minutes after the original post[T] [B] #307,946
@previous (quack )
Well the problem is, I have literally no knowledge on mysql syntax, so I don't know what I'd need to do to make it match. And the second part; I'm not sure how I'd find something like that out. The developer didn't specify what they used to test the file.
Also, thanks for the reply.
Well the problem is, I have literally no knowledge on mysql syntax, so I don't know what I'd need to do to make it match. And the second part; I'm not sure how I'd find something like that out. The developer didn't specify what they used to test the file.
Also, thanks for the reply.
+Dr. Autphag !FaiGWhdD4g — 13 years ago, 18 minutes later, 39 minutes after the original post[T] [B] #307,949
@previous (Beebs !!2dE4HTCjq)
Then you're probably not fit to administrate a board either.
Besides don't they have a developer's board for this kind of shit?
Then you're probably not fit to administrate a board either.
Besides don't they have a developer's board for this kind of shit?
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 3 minutes later, 42 minutes after the original post[T] [B] #307,950
@previous (Dr. Autphag !FaiGWhdD4g)
Not sure. And I've run imageboards before. I'm learning mysql at the moment, so I'm obviously going to suck at knowing things, nigger. Anyway, meth has really caused you to be very angry. Might want to work on that a bit.
Not sure. And I've run imageboards before. I'm learning mysql at the moment, so I'm obviously going to suck at knowing things, nigger. Anyway, meth has really caused you to be very angry. Might want to work on that a bit.
·quack — 13 years ago, 4 minutes later, 46 minutes after the original post[T] [B] #307,951
looking for the recommended dbms is probably your safest bet because theres a chance the php code contains more dbms specifics than u think and it would be really tedious to change everything.
·Dr. Autphag !FaiGWhdD4g — 13 years ago, 46 seconds later, 47 minutes after the original post[T] [B] #307,952
@307,950 (Beebs !!2dE4HTCjq)
I'm not vexed, contrarily, I was being rather forthright in my advice for you to make abortive this endeavour prior to potential failure.
I'm not vexed, contrarily, I was being rather forthright in my advice for you to make abortive this endeavour prior to potential failure.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 48 minutes after the original post[T] [B] #307,953
@previous (Dr. Autphag !FaiGWhdD4g)
> word-salad
Take your meth-induced ramblings elsewhere.
@307,951 (quack )
Alright, I'll do some research. Much appreciated.
> word-salad
Take your meth-induced ramblings elsewhere.
@307,951 (quack )
Alright, I'll do some research. Much appreciated.
+Anonymous D — 13 years ago, 3 minutes later, 52 minutes after the original post[T] [B] #307,955
·Dr. Autphag !FaiGWhdD4g — 13 years ago, 1 minute later, 53 minutes after the original post[T] [B] #307,956
@previous (D)
I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 55 minutes after the original post[T] [B] #307,957
@previous (Dr. Autphag !FaiGWhdD4g)
> I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
> I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
·quack — 13 years ago, 2 minutes later, 57 minutes after the original post[T] [B] #307,958
@307,953 (Beebs !!2dE4HTCjq)
you could download the EBNF grammars for all the major sql dialects then use antlr to create a tree parser n see which of them accepts your SQL file. jk.
you could download the EBNF grammars for all the major sql dialects then use antlr to create a tree parser n see which of them accepts your SQL file. jk.
·Anonymous D — 13 years ago, 40 seconds later, 58 minutes after the original post[T] [B] #307,959
@307,956 (Dr. Autphag !FaiGWhdD4g)
> I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
> >Well no wonder they fail, with that attitude.
> I heard the sound of a spineless, atesticular mouse attempting to quotemine me without context. Odd...
> >Well no wonder they fail, with that attitude.
+Red Creme !Soda7m0OQk — 13 years ago, 13 minutes later, 1 hour after the original post[T] [B] #307,962
Which version of ATBBS is it?
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 1 hour after the original post[T] [B] #307,963
·Red Creme !Soda7m0OQk — 13 years ago, 3 minutes later, 1 hour after the original post[T] [B] #307,965
@previous (Beebs !!2dE4HTCjq)
Where'd you get it from?
The presence of a sticky flag would indicate this isn't one of my builds.
Where'd you get it from?
The presence of a sticky flag would indicate this isn't one of my builds.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 1 hour after the original post[T] [B] #307,966
·Red Creme !Soda7m0OQk — 13 years ago, 8 minutes later, 1 hour after the original post[T] [B] #307,970
@previous (Beebs !!2dE4HTCjq)
No, but I adopted it as a pet project. http://atbbs.lostsig.co/ is my site.
It looks like Vocalon posted his work to sourceforge. I don't know why he never said anything about it. :(
No, but I adopted it as a pet project. http://atbbs.lostsig.co/ is my site.
It looks like Vocalon posted his work to sourceforge. I don't know why he never said anything about it. :(
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 1 hour after the original post[T] [B] #307,971
@previous (Red Creme !Soda7m0OQk)
I basically just googled 'atbbs' and that was the first link. Lol. And would you recommend me switching to your version? Or would both give me the same error because of my db syntax issue?
I basically just googled 'atbbs' and that was the first link. Lol. And would you recommend me switching to your version? Or would both give me the same error because of my db syntax issue?
+Anonymous F — 13 years ago, 1 hour later, 2 hours after the original post[T] [B] #307,984
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 5 minutes later, 2 hours after the original post[T] [B] #307,986
+Antikhristos !M6R0eWkIpk — 13 years ago, 2 minutes later, 2 hours after the original post[T] [B] #307,987
@307,970 (Red Creme !Soda7m0OQk)
> Nice try, bot. SHITLISTED!!!
Gawddamnit.
@307,952 (Dr. Autphag !FaiGWhdD4g)
What a negative Nancy.
> Nice try, bot. SHITLISTED!!!
Gawddamnit.
@307,952 (Dr. Autphag !FaiGWhdD4g)
What a negative Nancy.
·Syntax — 13 years ago, 7 minutes later, 2 hours after the original post[T] [B] #307,991
@307,986 (Beebs !!2dE4HTCjq)
Ya that was Thee. Don't have a clue why Red Cream put the files in FAQ instead of a Tab labeled most proper.
Ya that was Thee. Don't have a clue why Red Cream put the files in FAQ instead of a Tab labeled most proper.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 6 minutes later, 2 hours after the original post[T] [B] #307,992
·Red Creme !Soda7m0OQk — 13 years ago, 44 minutes later, 3 hours after the original post[T] [B] #308,013
@307,991 (Syntax )
files in FAQ? wat?
Oh, you mean you found the link to files in the FAQ. Did you not see the tab labelled "Repository" right under the board name?
You can also view the raw directory if you prefer: http://atbbs.lostsig.com/rep/
files in FAQ? wat?
Oh, you mean you found the link to files in the FAQ. Did you not see the tab labelled "Repository" right under the board name?
You can also view the raw directory if you prefer: http://atbbs.lostsig.com/rep/
(Edited 2 minutes later.)
·Syntax — 13 years ago, 5 minutes later, 3 hours after the original post[T] [B] #308,016
+The Doctor !7MHPahvoGY — 13 years ago, 1 hour later, 5 hours after the original post[T] [B] #308,041
·Red Creme !Soda7m0OQk — 13 years ago, 6 minutes later, 5 hours after the original post[T] [B] #308,042
@307,987 (Antikhristos !M6R0eWkIpk)
I'm a little surprised how well the filter works. I might get 1 spampost in 3 months.
I'm a little surprised how well the filter works. I might get 1 spampost in 3 months.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 hour later, 6 hours after the original post[T] [B] #308,057
+Anonymous I — 13 years ago, 1 hour later, 8 hours after the original post[T] [B] #308,084
·The Doctor !7MHPahvoGY — 13 years ago, 19 minutes later, 8 hours after the original post[T] [B] #308,088
·Anonymous I — 13 years ago, 8 minutes later, 8 hours after the original post[T] [B] #308,091
·The Doctor !7MHPahvoGY — 13 years ago, 6 minutes later, 8 hours after the original post[T] [B] #308,093
·Anonymous I — 13 years ago, 13 minutes later, 9 hours after the original post[T] [B] #308,098
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 15 hours later, 1 day after the original post[T] [B] #308,214
@308,013 (Red Creme !Soda7m0OQk)
Your code has a bug in it that prevents topics from being listed on the front page. Would you happen to know how I can fix this?
Your code has a bug in it that prevents topics from being listed on the front page. Would you happen to know how I can fix this?
·Red Creme !Soda7m0OQk — 13 years ago, 9 minutes later, 1 day after the original post[T] [B] #308,216
@previous (Beebs !!2dE4HTCjq)
I've been aware of this for quite some time and have been unable to find the fix. I think it has something to do with the cookies not being saved immediately. Once you set some stuff in the dashboard the problem goes away.
I've been aware of this for quite some time and have been unable to find the fix. I think it has something to do with the cookies not being saved immediately. Once you set some stuff in the dashboard the problem goes away.
·Syntax — 13 years ago, 42 minutes later, 1 day after the original post[T] [B] #308,228
@previous (Red Creme !Soda7m0OQk)
Hummmmmmm and you failed to list unfixed issues?
Me thinks some of the Creme has gone sour.
Hummmmmmm and you failed to list unfixed issues?
Me thinks some of the Creme has gone sour.
·Red Creme !Soda7m0OQk — 13 years ago, 9 minutes later, 1 day after the original post[T] [B] #308,230
@previous (Syntax )
http://atbbs.lostsig.co/topic.php?id=25
It's been discussed but you'd have had to force generate your cookie to see the threads.
http://atbbs.lostsig.co/topic.php?id=25
It's been discussed but you'd have had to force generate your cookie to see the threads.
·Anonymous F — 13 years ago, 32 minutes later, 1 day after the original post[T] [B] #308,242
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 49 minutes later, 1 day after the original post[T] [B] #308,251
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 28 minutes later, 1 day after the original post[T] [B] #308,256
@308,216 (Red Creme !Soda7m0OQk)
Also, the site I'm using it for is going through to Tor network, so what would I be able to do for moderator accounts? Is it possible to completely switch the id system to account rather than uid?
Also, the site I'm using it for is going through to Tor network, so what would I be able to do for moderator accounts? Is it possible to completely switch the id system to account rather than uid?
·Red Creme !Soda7m0OQk — 13 years ago, 13 minutes later, 1 day after the original post[T] [B] #308,259
@previous (Beebs !!2dE4HTCjq)
I'm not familiar with how tor works, but the uid system is essentially an automated version of the traditional register/login method. I did at one point set up a hack of ATBBS as a private board where account creation was done manually by myself and coordinated via irc. That was the only board to actually function with (a slight variation of) the leaked version ltamake put on github. I don't know if that's what you mean though.
I'm not familiar with how tor works, but the uid system is essentially an automated version of the traditional register/login method. I did at one point set up a hack of ATBBS as a private board where account creation was done manually by myself and coordinated via irc. That was the only board to actually function with (a slight variation of) the leaked version ltamake put on github. I don't know if that's what you mean though.
(Edited 21 seconds later.)
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 hour later, 1 day after the original post[T] [B] #308,282
@previous (Red Creme !Soda7m0OQk)
Yeah it's alright. I got another plan present itself. Thanks though
Yeah it's alright. I got another plan present itself. Thanks though
·quack — 13 years ago, 48 minutes later, 1 day after the original post[T] [B] #308,296
ur the guy running opva2
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 55 minutes later, 1 day after the original post[T] [B] #308,319
@previous (quack )
Lul. I've heard about that site but I have no idea what it is. I'm assuming a pedo gathering place like the rest of 95% of tor.
Lul. I've heard about that site but I have no idea what it is. I'm assuming a pedo gathering place like the rest of 95% of tor.
·DUCKY QUACK DUCKY QUACK DUCKY — 13 years ago, 1 hour later, 1 day after the original post[T] [B] #308,343
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 34 minutes later, 1 day after the original post[T] [B] #308,347
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 21 minutes later, 1 day after the original post[T] [B] #308,358
@308,216 (Red Creme !Soda7m0OQk)
Looks like that worked. The default values on the items per page (or any other, maybe) are what stops the posts from showing. Also, apparently switching up the stylesheet will make the site title appear for the first time. I assume you already know all of this, but if not, there you go. Lol
Looks like that worked. The default values on the items per page (or any other, maybe) are what stops the posts from showing. Also, apparently switching up the stylesheet will make the site title appear for the first time. I assume you already know all of this, but if not, there you go. Lol
+Anonymous J — 13 years ago, 1 minute later, 1 day after the original post[T] [B] #308,359
+Anonymous K — 13 years ago, 52 minutes later, 1 day after the original post[T] [B] #308,374
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 8 minutes later, 1 day after the original post[T] [B] #308,382
@308,259 (Red Creme !Soda7m0OQk)
I think I found the bug.
In line 163 of dashboard.php, it should say:
I changed the 0 that comes after the || to 100 to match the beginning value and it seemed to do the trick.
I think I found the bug.
In line 163 of dashboard.php, it should say:
<option value="100"<?php if($user_config['items_per_page'].100 || $user_config['items_per_page']
0) echo ' selected' ?>>100 (default)</option>
I changed the 0 that comes after the || to 100 to match the beginning value and it seemed to do the trick.
·Anonymous K — 13 years ago, 21 minutes later, 1 day after the original post[T] [B] #308,398
@previous (Beebs !!2dE4HTCjq)
Do you use Linux or watch anime?
Is your joy in life to play Minecraft?
You are most certainly mentally ill.
Do you use Linux or watch anime?
Is your joy in life to play Minecraft?
You are most certainly mentally ill.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 1 day after the original post[T] [B] #308,400
@previous (K)
> Do you use Linux or watch anime?
No. I use Windows and know nothing about anime.
> Is your joy in life to play Minecraft?
I've played Minecraft, but never got into it.
> You are most certainly mentally ill.
It's a possibility.
> Do you use Linux or watch anime?
No. I use Windows and know nothing about anime.
> Is your joy in life to play Minecraft?
I've played Minecraft, but never got into it.
> You are most certainly mentally ill.
It's a possibility.
·Anonymous K — 13 years ago, 4 minutes later, 1 day after the original post[T] [B] #308,401
@previous (Beebs !!2dE4HTCjq)
I'm glad you gave me honest, legitimate answers. You should drop ATBBS and make your own software from scratch, bundled with patented hardware which scans the user in order to determine whether or not he/she is a ginger.
I'm glad you gave me honest, legitimate answers. You should drop ATBBS and make your own software from scratch, bundled with patented hardware which scans the user in order to determine whether or not he/she is a ginger.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 1 minute later, 1 day after the original post[T] [B] #308,402
@previous (K)
I don't know enough about php or coding in general to make something that elaborate. Though I do like the ginger scanner. I could make an algorithm that finds posts that have the same/similar level of autism as my posts and they'll be given VIP "Ginger" status.
I don't know enough about php or coding in general to make something that elaborate. Though I do like the ginger scanner. I could make an algorithm that finds posts that have the same/similar level of autism as my posts and they'll be given VIP "Ginger" status.
·Anonymous K — 13 years ago, 19 minutes later, 1 day after the original post[T] [B] #308,415
@previous (Beebs !!2dE4HTCjq)
That's an impressive idea nonetheless. Kimmo would have killed to get ahold of something like that. It would automatically distinguish PSYCHOTIC FUCKTARDS from QUALITY CONTRIBUTORS.
That's an impressive idea nonetheless. Kimmo would have killed to get ahold of something like that. It would automatically distinguish PSYCHOTIC FUCKTARDS from QUALITY CONTRIBUTORS.
·quack — 13 years ago, 25 minutes later, 1 day after the original post[T] [B] #308,432
·Anonymous K — 13 years ago, 24 minutes later, 1 day after the original post[T] [B] #308,444
@previous (quack )
Oh really? That's astounding! I'm always eager to hear about your endeavors in education, though I think a class on living with aspergers would be more useful of your time and money.
Oh really? That's astounding! I'm always eager to hear about your endeavors in education, though I think a class on living with aspergers would be more useful of your time and money.
+Anonymous L — 13 years ago, 1 minute later, 1 day after the original post[T] [B] #308,446
+finland !E.2uE3Aybc — 13 years ago, 2 hours later, 1 day after the original post[T] [B] #308,522
I have the weirdest boner right now
·Red Creme !Soda7m0OQk — 13 years ago, 15 hours later, 2 days after the original post[T] [B] #308,643
@308,382 (Beebs !!2dE4HTCjq)
so you changed the
] 0)
to
] 100)
??
I tried that but my board is still saying no topics on first visit.
so you changed the
] 0)
to
] 100)
??
I tried that but my board is still saying no topics on first visit.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 3 hours later, 2 days after the original post[T] [B] #308,715
@previous (Red Creme !Soda7m0OQk)
Weird. It worked the first time I tried it out, but apparently stopped working or I was incorrect. But from what I could tell from my fidgeting is that every selection but the default 100 items in a page will work fine. Just can't seem to change the default to something else.
Weird. It worked the first time I tried it out, but apparently stopped working or I was incorrect. But from what I could tell from my fidgeting is that every selection but the default 100 items in a page will work fine. Just can't seem to change the default to something else.
·Red Creme !Soda7m0OQk — 13 years ago, 27 minutes later, 2 days after the original post[T] [B] #308,727
@previous (Beebs !!2dE4HTCjq)
I think the problem is caused specifically because the cookie isn't being created immediately on the client side. The cookie is used to store data about topics and preferences as well as serve to automatically log you in when you visit the site. When you first visit, the site creates an account for you, logs you in, and activates your session. After a certain amount of not doing anything, the site automatically logs you out again. Since the site logs you in the first time, I don't think the cookie actually has to be written in order to browse initially, there are just some actions which force writing to the cookie in order to store stuff. I think it's just not forcing the cookie to be written immediately.
I think the problem is caused specifically because the cookie isn't being created immediately on the client side. The cookie is used to store data about topics and preferences as well as serve to automatically log you in when you visit the site. When you first visit, the site creates an account for you, logs you in, and activates your session. After a certain amount of not doing anything, the site automatically logs you out again. Since the site logs you in the first time, I don't think the cookie actually has to be written in order to browse initially, there are just some actions which force writing to the cookie in order to store stuff. I think it's just not forcing the cookie to be written immediately.
·Beebs !!2dE4HTCjq (OP) — 13 years ago, 14 minutes later, 2 days after the original post[T] [B] #308,729
·Red Creme !Soda7m0OQk — 13 years ago, 1 hour later, 2 days after the original post[T] [B] #308,740
@308,522 (finland !E.2uE3Aybc)
Hey, can you grab the copy of 1.5 stable from my site and identify what part of dashboard.php writes to the cookie?
Hey, can you grab the copy of 1.5 stable from my site and identify what part of dashboard.php writes to the cookie?
·finland !E.2uE3Aybc — 13 years ago, 4 hours later, 2 days after the original post[T] [B] #308,842
@previous (Red Creme !Soda7m0OQk)
Is this to get over the theme not setting/no topics issue? It just needs a SQL entry added for the user id in the `user_settings` table IIRC. That can be added to the original cookie setting function in functions.php. I am pretty sure the OOPHP at the top and bottom of dashboard.php do all the dirty work.
Is this to get over the theme not setting/no topics issue? It just needs a SQL entry added for the user id in the `user_settings` table IIRC. That can be added to the original cookie setting function in functions.php. I am pretty sure the OOPHP at the top and bottom of dashboard.php do all the dirty work.
Start a new topic to continue this conversation.
Or browse the latest topics.