1.5.1 RC1, SE Store, and SE User Survey!

[charpress]

I did upload and re-run upgrade.php.

I'll try the query next.

[charpress]

Oops, what's wrong here:

ALTER TABLE {$db_prefix}log_online ADD PRIMARY KEY (identity(30))

MySQL said:


You have an error in your SQL syntax near '{$db_prefix}log_online ADD PRIMARY KEY (identity(30))' at line 1

[[Unknown]]

Replace {$db_prefix} with yuor prefix.... ie. yabbse_.

-[Unknown]

[Tenkoy]

Okay, I'm pretty sure you've heard this question before, and it probably isn't an issue with this, but I can never be certain. I looked through the archives and couldn't find an answer that helped.

I got this error when I tried to apply a yabbpak.

2: mkdir() failed (No such file or directory)
(/home/virtual/site29/fst/var/www/html/yabbse/Sources/Packer.php ln 108)

It's probably a configuration error with my forum, rather than an error with the system.

[[Unknown]]

Okay, I'm pretty sure you've heard this question before, and it probably isn't an issue with this, but I can never be certain. I looked through the archives and couldn't find an answer that helped.

I got this error when I tried to apply a yabbpak.

2: mkdir() failed (No such file or directory)
(/home/virtual/site29/fst/var/www/html/yabbse/Sources/Packer.php ln 108)

It's probably a configuration error with my forum, rather than an error with the system.

Sounds like either a configuration problem or a mod problem.... which mod is it?

-[Unknown]

[charpress]

Sorry, I look at things literally. My prefixes are yabbse_, so do you mean:

ALTER TABLE {$yabbse_}log_online ADD PRIMARY KEY (identity(30))

[Tenkoy]

tdodnz's mods.

Disable Avatars
Disable Signatures
Auto Message

They're for 1.5, so I figured they'd work for this one too.

[David]

They're for 1.5, so I figured they'd work for this one too.

A lot has chnaged since 1.5, I highly doubt any 1.5 mods will work.

[Jeff Lewis]

charpress, are you trying to apply this in phpmyadmin? If so remove the {}

[charpress]

Figured out what you meant, but now:

ALTER TABLE yabbse_log_online ADD PRIMARY KEY (identity(30))

MySQL said:


Duplicate entry '216.83.233.20' for key 1

[Tenkoy]

Alrighty, thanks, that helps a lot.

[Jeff Lewis]

charpress, of course you need to clean out your log_online table. Can do it via the admin center and clear active log.

[[Unknown]]

Figured out what you meant, but now:

ALTER TABLE yabbse_log_online ADD PRIMARY KEY (identity(30))

MySQL said:


Duplicate entry '216.83.233.20' for key 1

DELETE FROM yabbse_log_online

Do that first.

-[Unknown]

[charpress]

Crap.

I was deleting multiple users and deleted one too many --so now no administrator.

I give up for today. Now I need to go read all the posts on what to do if the amin gets deleted.

I even missed being first to catch the magic llama.

[[Unknown]]

INSERT INTO yabbse_members (memberName, realName, passwd, emailAddress, posts, personalText, avatar, dateRegistered, hideEmail, memberIP, im_email_notify, memberGroup)
VALUES ('admin', 'admin', 'adpexzg3FUZAk','[email protected]', 0, 'I\'m an admin!','blank.gif',UNIX_TIMESTAMP(), '0', '127.0.0.1', 1, 'Administrator')

Should work...

[edit: Added Administrator ]

-[Unknown]