can not create dir in file center

[Jensensen]

thanks flip-flop,
btw. my DB holds 45 tables only --> one is missing:= phpwcms_log

has been a clean install | for testing only
codebase was: SVN r_xxx

hä?

will try another "clean install"
[die laughing]

[flip-flop]

@Jens: phpwcms_log is empty. It isn´t in use at this time. This shown table is an updated one from an older version.

@1996 328ti

Code: Select all

Indexes:
-------------------------------------------------------------------
Keyname      Type      Cardinality     Action          Field
-------------------------------------------------------------------
PRIMARY      PRIMARY   0               [Edit] [Drop]   f_id
f_granted    INDEX     None            [Edit] [Drop]   f_granted
f_name       INDEX     None            [Edit] [Drop]   f_name
f_shortinfo  INDEX     None            [Edit] [Drop]   f_shortinfo
-------------------------------------------------------------------

[Jensensen]

this is mine: v1.3.9 R_273



as you can see:

f_vars is missing!!!! in yours ??!!¿¿

btw: R_273 DEVWARE adds ONLY 45 tables to the database!!!!

[EDIT]
@flip: I understand.
[/EDIT]

[1996 328ti]

Ahh. I did not look at the bottom of the page.
This is what I see.

[juergen]

so...

fvars is missing, just redo in setup : 1.3.5-> 1,5

Code: Select all

# 2008-08-21
ALTER TABLE `phpwcms_file` ADD `f_vars` BLOB NOT NULL ;

Done and gone

[flip-flop]

I think that isn´t the problem. Can´t find any usage of f_var.

Knut

[1996 328ti]

SOLVED!

I don't know if this will help someone else down the line, but. . .
My test site was upgraded from 1.3.3 to 1.3.9 just as my live site was.
On both sites I could not create a new dir in the file center.
So. . .

I saved my database on the test site.
Deleted all tables. Installed 1.3.9.
Emptied all tables.
Loaded my data back. I got all sorts of errors.
Emptied all tables.
Inserted each table one at a time.
Now I could create directories.

To my live site.
Deleted my tables. Installed 1.3.9.
Emptied all tables. Inserted my data but got errors in the ads table.
Emptied my tables. Installed my live database back.
Checked to see that I could create directories, YES.

Not sure if my data is clean. I'll probably go back and look closer at the different ads tables.
What are they for anyway?

Oh well.
Thanks to those who helped.
Now for a nice Belgium beer.