| 08:28 |
PiMB |
morning all |
| 08:51 |
ndee |
if you had to index word, excel, PDFs, etc, which search engine would you use for typo3? |
| 08:52 |
PiMB |
I believe indexed_search could do it. |
| 08:52 |
PiMB |
but I would say that depends on the amount being indexed. |
| 08:52 |
PiMB |
won't use indexed search if site is to large. |
| 08:52 |
ndee |
PiMB: it's for an intranet with some documents. I'd say the data that has to be indexed is around 1GB |
| 08:53 |
ndee |
max. 1GB |
| 08:53 |
BejjWrk |
grr brb |
| 08:53 |
BejjWrk |
there we go |
| 08:53 |
PiMB |
well, I know Ingo Renner is working on some Solr in TYPO3. |
| 08:53 |
PiMB |
not sure how far along they are. |
| 08:53 |
PiMB |
but I hear that it's good |
| 08:54 |
BejjWrk |
morning PiMB , morning dsa |
| 08:54 |
PiMB |
Morning BejjWrk |
| 08:55 |
ndee |
PiMB: yes, I've read that too. So I could try indexed_search and if it's not enough, I could still try solr. |
| 08:58 |
maholtz|WORK |
morning |
| 09:28 |
marfola |
hi |
| 09:29 |
PiMB |
morning |
| 09:29 |
marfola |
i have a question |
| 09:29 |
marfola |
I use the realurl plugin. |
| 09:29 |
marfola |
My extensions arent USER_INT. Ive run a search on all my extensions and none are set to no_cache=1 |
| 09:30 |
marfola |
Im trying to make typo3 send cache control headers (cache private) for some of the pages of my typo3 website. Ive disabled the no_cache flag in each template of my tree. I've set the config.no_cache = 0 in the main, top most template. I've set the flag SendCacheHeaders=1 in the main, top most template. |
| 09:30 |
marfola |
The unmapped url returns a cache control:private header. The mapped urls return the following header: Cache Control: private Pragma:no cache Expires: 1981. |
| 09:30 |
marfola |
Who is setting the no_cache control? |
| 09:30 |
marfola |
Any suggestions. I'm sure I've missed something basic. |
| 10:20 |
coolguy |
hi there. is someone familiar with typo3 4.3.0 ? |
| 10:31 |
coolguy |
hello. iam using typo3 4.3.0 and it seems that the image scaling does not work properly. when i add an text with image content element and add a image. |
| 10:32 |
coolguy |
when i set the size to 150 px in the properties |
| 10:32 |
coolguy |
i image gets not resized |
| 10:32 |
coolguy |
its always in original size |
| 10:35 |
ycas_away |
hello. i want to have gifs as separetors between my horizontal HMENU; any hint how to format them (like align or so)? Or is there a way to use GMENU with a dynamical width, as it is a horizontal menu? Thx in advance |
| 10:36 |
Denjerek |
coolguy: have you included the static template "CSS Styled Content" |
| 10:36 |
Denjerek |
ycas_away: I'd just style those in with CSS |
| 10:39 |
ycas_away |
Denjerk: ok, thank you! |
| 10:41 |
Denjerek |
If you need an example, check out the styling on www.cfaccessories.com |
| 10:41 |
Denjerek |
I did a similar thing there on the top menu. |
| 10:51 |
ycas_away |
Denjerek: great design. and thats the way I am trying. thx for the link! |
| 10:55 |
coolguy |
yes its included |
| 10:55 |
coolguy |
it all works fine instead of this |
| 11:13 |
Georges_Abitbol |
I want in an extension plugin to get a constant from another extension. How could I do it ? |
| 11:16 |
WinstonS |
hi. |
| 11:32 |
ycas |
#join #macosx |
| 11:37 |
WinstonS |
i'm using typo3 4.3.1 on ubuntu 9.10, apache 2.2.12, php 5.2.10, mysql 5.1. I just did a fresh install, install tool is all green, i can login to the backend as admin, but it seems i cannot create any pages or import any template. is there anything i am missing? |
| 11:47 |
Denjerek |
Is this your first time using Typo3? |
| 11:49 |
Echidna |
hi |
| 11:50 |
WinstonS |
Denjerek, yes, it is. |
| 11:51 |
WinstonS |
i'm trying to work with the tutorials and documentation, but i fail at the first step already. it just does not seem to create any page, or even the page tree |
| 11:52 |
Echidna |
this mysql db i use with typo3 has ANSI_QUOTES activated, which causes queries like [SELECT pi_flexform FROM `tt_content` WHERE uid="3"] to fail |
| 11:52 |
Echidna |
is there a way to make typo3 not use double quotation marks for strings? |
| 11:53 |
Denjerek |
WinstonS: a LOT of Typo3 documentation is stinking old. |
| 11:53 |
Denjerek |
Including a lot of the absolutely key tutorials. |
| 11:53 |
Denjerek |
this is a most unfortunate facet of working with Typo3, they really try to make it hard to find the good document :) |
| 11:53 |
Denjerek |
Do you have the tutorial "Futuristic template building" ? |
| 11:54 |
Denjerek |
(because, if you weren't aware, we're in the future now! :)) |
| 11:54 |
WinstonS |
uhm, so far i tried "modern template building". is the futuristic one on typo3.org also? |
| 11:56 |
WinstonS |
ah, got it. |
| 11:58 |
Denjerek |
Right |
| 11:58 |
Denjerek |
Forget modern. |
| 11:58 |
Denjerek |
think of the future. |
| 11:58 |
Denjerek |
you'll thank me in the longrun. |
| 11:59 |
WinstonS |
and this is where it fails again. my page tree right now is the globe "New TYPO3 website". it wont let me add any page. |
| 11:59 |
Denjerek |
The modern tempplate building is all about subparts and markers |
| 11:59 |
Denjerek |
Right |
| 11:59 |
WinstonS |
i thank you already, any hint is appreciated :) |
| 11:59 |
Denjerek |
If you click on the globe, you should get a popup menu? |
| 12:00 |
WinstonS |
yep, i go to new page (inside), fill in the page title, untick "hide page", save, and nothing. |
| 12:01 |
WinstonS |
(i installed both typo3_src and the dummy page source) |
| 12:02 |
WinstonS |
typo3_src resides in /var/wwwtools/typo3_src, the dummy page in /var/www/typo01 . symlinks are set. |
| 12:02 |
Denjerek |
Do you see a small plus sign next to the globe? |
| 12:03 |
WinstonS |
yep, i tried to unfold, the page does not show up. tried to clear the caches, relogin etc. nothing works. |
| 12:03 |
Denjerek |
I can take a really quick look if you PM me a backend login. |
| 12:03 |
Denjerek |
Echidna: I'm not sure about that. I think there's a DBAL to accomodate different configs, though? |
| 12:03 |
WinstonS |
the dev box is not connected to the internet :/ |
| 12:04 |
WinstonS |
(it is, but it cannot be reaced from outside, to be more precise) |
| 12:05 |
Denjerek |
Hmm. |
| 12:05 |
Denjerek |
I'm trying to imagine the steps I go through. |
| 12:05 |
WinstonS |
thank you |
| 12:05 |
Echidna |
Denjerek: do you know something changed in that area between 4.2.9 and 4.3? because i dont get those errors in 4.3 afaik |
| 12:05 |
Denjerek |
but without having the buttons in front of me to click... |
| 12:05 |
Denjerek |
Echidna: I'm afraid I don't. I have never had to meddle with the DB layer |
| 12:05 |
WinstonS |
heh, yeah, i know that feeling ;) |
| 12:05 |
Denjerek |
WinstonS: what happens if you click the template module ? |
| 12:06 |
WinstonS |
the template page shows up, no template installed. the table is empty. |
| 12:07 |
WinstonS |
i tried to import some free templates, but it failed also. "preview" did not seem to work also. |
| 12:09 |
WinstonS |
does the typo3 database user need grant privileges? |
| 12:16 |
Echidna |
Denjerek. ok, 4.3 doesn't seem to have this problem |
| 12:21 |
Denjerek |
WinstonS: not usually I don't think. |
| 12:21 |
Denjerek |
WinstonS: The "standard" templates are a headache. |
| 12:21 |
Denjerek |
does Futuristic Template Bulding (FTB) work through creating your first page ? |
| 12:21 |
Denjerek |
I cannot rememeber. |
| 12:22 |
Denjerek |
Maybe you could screenshare with me ? |
| 12:22 |
Denjerek |
i recommend also looking at your apache , php and mysql error logs |
| 12:23 |
Denjerek |
Just in case there is something lower-down that's causing an issue. |
| 12:40 |
ycas |
can i use after = </div> afterImg = fileadmin/templates/vwe/trennlinie.gif |
| 12:41 |
ycas |
for a single object? i want to have a nbsp; before the gif. somehow, it does not work |
| 12:43 |
WinstonS |
Denjerek, sorry for the delay. i did check the logs by now, nothing shows up. screenshare is not possible, i'm afraid. |
| 12:45 |
Denjerek |
Well WinstonS, I can try and help you this evening when I get home, but I am on site until 1730hrs GMT |
| 12:45 |
Denjerek |
Without access to either your screen, or a clean Typo3 install, I can't think what to suggest. |
| 12:45 |
Denjerek |
You are logging in as an administrator, correct? |
| 12:46 |
WinstonS |
to the backend? yep. using the default admin : password credentials |
| 12:46 |
Denjerek |
Can you link me to the FTB doc? |
| 12:46 |
Denjerek |
Preferably the online version |
| 12:46 |
Denjerek |
(No OO here) |
| 12:46 |
Denjerek |
ycas: link to the site please? |
| 12:55 |
ycas |
Denjarek: http://feuerungsleistungsregelung.info/branchen/ |
| 12:55 |
ycas |
root lvl is hidden |
| 12:56 |
ycas |
but i am supposed to create those separators, changing on hover etc. |
| 12:57 |
ycas |
i know there is way to go, but i don't want the grafics 'sticking' to the menu entries |
| 13:03 |
Denjerek |
YIKES |
| 13:03 |
Denjerek |
ok don't open that site in opera. |
| 13:03 |
Denjerek |
Or firefox. |
| 13:04 |
Denjerek |
Or IE |
| 13:04 |
Denjerek |
Ok so |
| 13:04 |
Denjerek |
Um |
| 13:04 |
Denjerek |
do you have a JPG of how the site should look when it's finished? |
| 13:04 |
ycas |
yea, a coworker messed around while i was absent |
| 13:04 |
ycas |
yes |
| 13:05 |
Denjerek |
Ok, post the screenshot. |
| 13:05 |
Denjerek |
Then go smack the co-worker |
| 13:05 |
Denjerek |
;) |
| 13:06 |
ycas |
noob question: how can i send files via irc? |
| 13:06 |
ycas |
he's my boss -.- |
| 13:06 |
Denjerek |
A link would be preferable |
| 13:06 |
Denjerek |
I'm unable to receive files |
| 13:06 |
Denjerek |
if you don't want to post a link to channel, PM it to me. |
| 13:06 |
ycas |
yea, wait a sec. have to upload it first |
| 13:08 |
mquintus |
if you want it fast, set #topnavi {top: 240px;} |
| 13:08 |
mquintus |
for the css problem |
| 13:08 |
ycas |
thx |
| 13:10 |
Bluespuke |
hello |
| 13:11 |
Bluespuke |
i've a straneg behaviour :s 'clear all caches' seems to end up in an infinite loop and makes the server freeze for like 1 minute... |
| 13:12 |
Bluespuke |
also saving a template ends up nowhere |
| 13:12 |
Bluespuke |
someone has some experience with that? |
| 13:12 |
Denjerek |
Which browser? |
| 13:13 |
Denjerek |
Which version of typo |
| 13:13 |
Denjerek |
which browser version |
| 13:13 |
Bluespuke |
nevermind, FF, IE, Chrome, Opera ans Safari... |
| 13:13 |
Bluespuke |
typo3 4.2.8 |
| 13:13 |
Denjerek |
Hmm |
| 13:13 |
Denjerek |
I've had some odd interface hangups in Opera |
| 13:13 |
Denjerek |
where you'll hit save and get a partially rendered BE interface. |
| 13:13 |
Denjerek |
But no infinite loops. |
| 13:13 |
Denjerek |
(Hey phil) |
| 13:14 |
WinstonS |
Denjerek, i enabled extended mysql logging. it looks like the the page is not INSERTed into the database when trying to save it. i've got no clue why, tho. |
| 13:14 |
Denjerek |
WinstonS: well that's some progress! |
| 13:14 |
Denjerek |
I seem to remember with one version of typo there was an issue with priviliges. |
| 13:14 |
Denjerek |
Which MySQL and typo versions are you using ? |
| 13:14 |
Bluespuke |
dunno if it's an infinite loop but it seems like it... the server has no response (i also tested with downforeveryoneorjustme.com) |
| 13:15 |
WinstonS |
typo3 4.3.1 (most recent stable), mysql 5.1.something (most recent on ubuntu 9.10) |
| 13:15 |
Denjerek |
Hmm |
| 13:15 |
Denjerek |
do you get an SQL error |
| 13:15 |
Denjerek |
or does it simply not appear in the DB? |
| 13:15 |
WinstonS |
the typo3 database user has been granted all privileges (without grant) on the typo3 database |
| 13:16 |
WinstonS |
it simply does not appear |
| 13:16 |
Denjerek |
Did you recurse those changes? |
| 13:16 |
Denjerek |
and give it specific access to the tableS? |
| 13:16 |
WinstonS |
will try, gimme a sec... |
| 13:16 |
Denjerek |
I'm sure I've had this problem before WinstonS, I'm just trying desperately to remember the details! |
| 13:16 |
WinstonS |
the typo3 user was able to create the tables while the install tool was running, tho. |
| 13:16 |
Denjerek |
Yeah |
| 13:17 |
Denjerek |
but it might not have created the *tables* correctly if there was some quirky security set up |
| 13:17 |
Denjerek |
*wracks brain* |
| 13:18 |
ycas |
Denjerek, thx, but i have no way of uploading the file. i will try to work it out. |
| 13:18 |
ycas |
thx so far! |
| 13:19 |
WinstonS |
thank you for your hints, Denjerek. i really appreciate |
| 13:19 |
Denjerek |
No worries |
| 13:19 |
Denjerek |
I remember first trying to use Typo3. |
| 13:19 |
Denjerek |
It was a complete bitch. |
| 13:19 |
WinstonS |
when saving the pages i see some selects, most likely typo3 session management, but no insert or update and stuff |
| 13:19 |
Denjerek |
This is me returning the help I received in here. |
| 13:20 |
Denjerek |
Can youc heck your typo3 log ? |
| 13:20 |
PiMB |
Denjerek +1 for that! |
| 13:21 |
WinstonS |
wow, thanks for the hint. there is some error that wasn't present before. lemme try to figure this out |
| 13:21 |
Denjerek |
PiMB: it's only fair :) Ries, PMK and Just2b were very patient :) |
| 13:21 |
Denjerek |
(in fact, they still are ;)) |
| 13:22 |
PiMB |
always are |
| 13:22 |
WinstonS |
unfortunately the error looks unrelated to me. it's about clearrtecache.php |
| 13:24 |
Denjerek |
hmm. |
| 13:24 |
WinstonS |
if i install typo3 and the dummy page, is it supposed to come with a dummy page tree already? or is this empty globe the default? |
| 13:24 |
Denjerek |
Yes quite. |
| 13:25 |
Denjerek |
right |
| 13:25 |
Denjerek |
Typo3 Source is exactly that |
| 13:25 |
Denjerek |
it's just the source for the CMS platform |
| 13:25 |
Denjerek |
not actually a website. |
| 13:25 |
Denjerek |
The dummy site zip/tar is a collection of files that initialises a blank Typo3 site |
| 13:25 |
Denjerek |
and in that essence, it's completely blank |
| 13:26 |
WinstonS |
heh. and all tutorials i've seen are using some page tree already |
| 13:26 |
Denjerek |
I believe your problem is lower down thans imply creating a page tree |
| 13:26 |
Denjerek |
as that is typically a trivial operation. |
| 13:26 |
Denjerek |
Click... click... done kinda thing. |
| 13:27 |
WinstonS |
is there any way to check if mysql on ubuntu is running in strict mode? |
| 13:27 |
Denjerek |
You say your log indicates an SQL query was submitted? |
| 13:27 |
WinstonS |
i remember some strict mode issues a bit ago. |
| 13:27 |
Denjerek |
SELECT @@GLOBAL.sql_mode; |
| 13:27 |
Denjerek |
SELECT @@SESSION.sql_mode; |
| 13:28 |
WinstonS |
yea, there are some selects on be_session and cache_hash |
| 13:28 |
WinstonS |
no inserts |
| 13:28 |
WinstonS |
ok, that's what i've thought. the vars are empty, so no strict mode, i guess. |
| 13:28 |
Denjerek |
WinstonS: http://wiki.typo3.org/index.php/TYPO3_Installation_on_Ubuntu_9.10 |
| 13:28 |
Denjerek |
check the MySQL config |
| 13:28 |
Denjerek |
there's a note about GRANT |
| 13:30 |
WinstonS |
exactly what i did |
| 13:31 |
Denjerek |
hmm. |
| 13:31 |
Denjerek |
On my local dev, apache is the www user |
| 13:31 |
Denjerek |
so all privs are granted to that |
| 13:32 |
Denjerek |
Can yuo identify which user is submitting the queries? |
| 13:33 |
WinstonS |
it's the typo3 user |
| 13:35 |
Denjerek |
WinstonS: http://wiki.typo3.org/index.php/TYPO3_Installation_Basics#SQL_safe_mode |
| 13:35 |
Denjerek |
Did youc heck the troubleshooting there? |
| 13:35 |
Denjerek |
Look for safe mode specifically |
| 13:36 |
Denjerek |
There's also Dmitrys excellent guide: http://dmitry-dulepov.com/fileadmin/e-books/TYPO3_installation_and_upgrade.pdf |
| 13:36 |
Denjerek |
OOH WOOOHOOHH |
| 13:36 |
Denjerek |
WINSTON! |
| 13:37 |
Denjerek |
I just had two ideas. |
| 13:37 |
Denjerek |
So quickly it almost hurt. |
| 13:37 |
Denjerek |
1st one: Click the DB Tools module, look for "Check reference index" |
| 13:37 |
Denjerek |
2nd: in the install tool there's an option for um, what's it called, some database thing |
| 13:37 |
Denjerek |
option 5 or 6 |
| 13:37 |
Denjerek |
can't rememeber off my own head. |
| 13:38 |
Denjerek |
anyway |
| 13:38 |
Denjerek |
in there you can compare the DB with what typo3 is expecting |
| 13:38 |
Denjerek |
and it'll tell you if things are messed up. |
| 13:39 |
Denjerek |
WinstonS: definately run through the checks in the DB Tools module,. |
| 13:39 |
WinstonS |
sql.safe_mode is off, according to php.ini |
| 13:40 |
WinstonS |
the reference index is ok, according to the db tool |
| 13:40 |
WinstonS |
and the "database things" also |
| 13:41 |
Denjerek |
Hmm. |
| 13:41 |
Denjerek |
heading home for lunch |
| 13:41 |
Denjerek |
will check my local dev server |
| 13:41 |
Denjerek |
brb |
| 13:41 |
WinstonS |
bon appetit, and thanks again :) |
| 13:58 |
Denyerec |
Et voila |
| 13:58 |
WinstonS |
wb |
| 13:58 |
WinstonS |
now that was a short way home |
| 13:58 |
Denyerec |
Mit food. |
| 13:58 |
Denyerec |
4 mninutes |
| 13:58 |
WinstonS |
bon appetit |
| 13:58 |
Denyerec |
I even had chance to cook. |
| 13:59 |
WinstonS |
wow. it's about 15 times yours for me ;) |
| 14:00 |
PiMB |
Cook == popped_into_microwace |
| 14:01 |
gerards |
try { microwave -> cook() } |
| 14:01 |
WinstonS |
*lol* |
| 14:01 |
WinstonS |
yep. exactly the same here |
| 14:01 |
gerards |
catch { exploding_microwave;} |
| 14:01 |
PiMB |
explode( microwave ); |
| 14:01 |
WinstonS |
try { microwave->put( cd ); } |
| 14:01 |
PiMB |
actually funny |
| 14:01 |
WinstonS |
looks funny. but ruins the microwave |
| 14:02 |
PiMB |
I had an explode( "\n",$body ); the other day |
| 14:02 |
PiMB |
which in turn became $a_bodyParts |
| 14:02 |
gerards |
$pieces = splice( self ); |
| 14:02 |
WinstonS |
i'm just glad it wasn'T $a_smellyFarts... |
| 14:03 |
Denyerec |
Fortunately I didn't fork() |
| 14:03 |
Denyerec |
annnyway :) |
| 14:03 |
PiMB |
little programmers humor, designer sitting next to me didn't think it was that funny |
| 14:03 |
Denyerec |
I presume you did the DB Tools integrity check ? |
| 14:03 |
WinstonS |
yep. all fine according to the checks |
| 14:03 |
WinstonS |
i cleared the cache_hash table, no results. |
| 14:04 |
WinstonS |
i disabled some php modules to get rid of "interference"... nothing |
| 14:04 |
WinstonS |
i'm quite clueless :/ |
| 14:05 |
Denyerec |
given that it's a local dev server |
| 14:05 |
Denyerec |
can you rule out SQL permission by giving the typo user root access? |
| 14:05 |
WinstonS |
good idea. do you think using the install tool to set the database user to "root" is sufficient? |
| 14:08 |
gerards |
sounds complicated Denyerec WinstonS. AFAIK, if install tool is happy with the DB connection, then it should work (the simple fact). Perhaps you should work from there....? |
| 14:12 |
WinstonS |
changing the database user to "root" didn't change the issue |
| 14:12 |
WinstonS |
gerards, install tool is "all green" |
| 14:13 |
WinstonS |
for both "root" and the typo3 database user |
| 14:13 |
BejjWrk |
WinstonS: are you pointing to an already existing database ? |
| 14:14 |
WinstonS |
yep. i created a database for typo3 and used the install tool to create the tables |
| 14:14 |
WinstonS |
according to the tool 44 tables were created |
| 14:15 |
WinstonS |
my sql "workflow": create typo3 database (utf8 charset, if that matters) ; create typo3 user; grant all on typo3 database.* to typo3 user; |
| 14:15 |
BejjWrk |
i used to get errors before when trying to make installtool connect to an existing db, worked fine when allowing it to create the db itself, tho, as you already have the db created, just edit the localconf.php to reflect the db settings ? |
| 14:16 |
Denyerec |
gerards -basically when he tries to create a page, nothing happens |
| 14:16 |
WinstonS |
the db settings look "ok" to me . i tested connecting using the mysql cli and the typo3 user, this works. |
| 14:17 |
WinstonS |
if i create a page in some way a database "insert" should happen, shouldn't it? |
| 14:19 |
gerards |
WinstonS: yes. you should see a new record in the "pages" table. |
| 14:19 |
gerards |
WinstonS: you should also see a new page in the page tree (the middle iframe in the Typo3 Backend (BE)) |
| 14:20 |
gerards |
WinstonS: if install tool is "all green" then I think its good to assume that the db connection is fine. (Denyerec, you agree?) |
| 14:20 |
Denyerec |
Connection, yes |
| 14:20 |
gerards |
if so, it must be something else. |
| 14:20 |
Denyerec |
permissions, not necessarily |
| 14:20 |
Denyerec |
I've certainly had an issue with a GRANT thing before |
| 14:21 |
gerards |
if he created the DB structure using install root, is it safe to assume that permissions will be set correctly? |
| 14:21 |
gerards |
if he created the DB structure using install tool, is it safe to assume that permissions will be set correctly? |
| 14:21 |
WinstonS |
i think so |
| 14:21 |
gerards |
if so then it must be something else. |
| 14:22 |
WinstonS |
yep. i've just got no clue about what else it could be. |
| 14:22 |
gerards |
its got to be something else. |
| 14:22 |
gerards |
you created a page but nothing appears in the BE. |
| 14:22 |
BejjWrk |
unless something went wrong during the creation of the tables and default population |
| 14:23 |
gerards |
can you create a user? |
| 14:23 |
WinstonS |
gimme a sec, i'll try |
| 14:23 |
gerards |
BejjWrk: if install tool is all green, then the tables should be created correctly. |
| 14:24 |
gerards |
Denyerec was right about the install tool. It should be a good first step. |
| 14:25 |
gerards |
maybe localconf.php is read-only. :) |
| 14:26 |
WinstonS |
no, i cannot create users also |
| 14:26 |
WinstonS |
and localconf is g+w for group www-data |
| 14:29 |
gerards |
WinstonS: I'm going to check my install tool. :) see if there is any permissions check there. |
| 14:29 |
WinstonS |
again, there's no insert statement in the mysql log. which confuses me |
| 14:30 |
WinstonS |
thanks gerards |
| 14:31 |
gerards |
in the install tool, under "Database Analyser", did you try to create "admin" user? |
| 14:31 |
gerards |
also can you try to "import" (also under "Database Analyser")? these steps should help confirm if you have write permissions to your DB. |
| 14:32 |
WinstonS |
i tried this a while ago (another attempt, did a clean install in the mean time), no success. i can login to the backend as admin tho, so the "admin" user exists |
| 14:32 |
Bluespuke |
maybe i'm annoying but this s***s... anyone has an idea why clear all caches and saving templates crashes/freezes the server? i tried in several browsers and OSs and also with downforeveryoneorjustme.com... (typo3 4.2.8) |
| 14:33 |
gerards |
what was the error WinstonS? |
| 14:33 |
WinstonS |
no error. |
| 14:34 |
gerards |
oh. no error but also no success? |
| 14:34 |
WinstonS |
yep. the "new page (inside)" jumps back to start when clicking "save". no error, but the page does not exist also |
| 14:35 |
gerards |
oh ok. |
| 14:35 |
gerards |
can you try to go to install tool and go to "Database Analyser", |
| 14:35 |
gerards |
and click on "import" (Dump static data)? |
| 14:36 |
WinstonS |
i use suhosin to harden php, in case this matters. the install tool is "green" for this also. |
| 14:36 |
WinstonS |
ok, will try |
| 14:36 |
gerards |
oh? really? hmmm..... can you try to disable that (Suhosin)? |
| 14:37 |
WinstonS |
select tables to import: static_template, rows: 61 (table exists) | static_tsconfig_help, rows: 117 (table exists) |
| 14:37 |
WinstonS |
will try to disable suhosin, but no idea if it can be easily disabled |
| 14:37 |
gerards |
can you try to truncate static_tsconfig_help? |
| 14:37 |
WinstonS |
how? |
| 14:38 |
gerards |
:) sounds really bad. "can you try to truncate static_tsconfig_help?" hahahaha! |
| 14:38 |
WinstonS |
who needs help anyways ;) |
| 14:38 |
gerards |
hahahah! |
| 14:38 |
gerards |
you can use, say, phpMyAdmin, |
| 14:39 |
WinstonS |
"imported 'static_tsconfig_help'" rows: 117 |
| 14:39 |
gerards |
i guess you can do something like delete from static_ts_config_help where true. |
| 14:39 |
gerards |
can you see if there are really 117 rows in static_tsconfig_help? |
| 14:39 |
WinstonS |
according to install tool the table will be dropped before import anyways |
| 14:39 |
WinstonS |
lemme check... |
| 14:41 |
WinstonS |
"describe static_tsconfig_help" -> 7 rows in set. hm. |
| 14:41 |
WinstonS |
using the mysql cli and the typo3 database user |
| 14:42 |
gerards |
don't do "describe"... what ever that does. :) try select count(*) from static_whatever; |
| 14:42 |
WinstonS |
117 it is |
| 14:42 |
gerards |
ok. I guess since you emptied static_xxxx and install tool put it back, |
| 14:43 |
gerards |
we can conclude that install tool has write privileges. |
| 14:43 |
WinstonS |
yep. now i also see the INSERT statement in the database log |
| 14:43 |
gerards |
am I correct? you did empty static_xxxx right? |
| 14:43 |
gerards |
great. |
| 14:43 |
gerards |
nothing wrong with write permissions. |
| 14:43 |
WinstonS |
neither create page nor create user generated INSERT or UPDATE statements |
| 14:43 |
gerards |
Its got to be something in the PHP code. |
| 14:43 |
Denyerec |
Hmmmn |
| 14:43 |
Denyerec |
Heading back on site |
| 14:44 |
Denyerec |
This is very, very odd. |
| 14:44 |
gerards |
something must be silently failing in the BE. |
| 14:44 |
WinstonS |
cya, Denjerek. take care. |
| 14:44 |
Denyerec |
back in 5 |
| 14:44 |
WinstonS |
using firefox 3.0.17 as browser |
| 14:44 |
gerards |
i doubt its the client side (browser). |
| 14:45 |
WinstonS |
me too. |
| 14:45 |
gerards |
I suspect PHP is failing very very quietly. |
| 14:45 |
WinstonS |
is there any way to enable extended logging or error output in typo3 code? |
| 14:45 |
maholtz|WORK |
you have trouble with database permissions? |
| 14:45 |
gerards |
if you can find the php log, or turn on php error logging it might help |
| 14:45 |
WinstonS |
like setting error_reporting( E_ALL ) somewhere? |
| 14:45 |
gerards |
ahhh... maholtz will know. |
| 14:46 |
gerards |
WinstonS: that won't work. |
| 14:46 |
maholtz|WORK |
perhaps compare localhost vs. 127.0.0.1 |
| 14:46 |
maholtz|WORK |
thats different on some servers |
| 14:46 |
maholtz|WORK |
and cli has different rights than normal mysql user |
| 14:46 |
WinstonS |
ok, i will add another grant for 127.0.0.1, but for what we've checked so far database permissions seem to be ok |
| 14:46 |
WinstonS |
localconf uses "localhost" as database host also. |
| 14:47 |
maholtz|WORK |
install tool database compare is ok too? |
| 14:47 |
gerards |
maholtz|WORK: install tool is able to create a table and write data to the table. We conclude that db read-write is fine. |
| 14:47 |
maholtz|WORK |
perhaps change it to 127.0.0.1 i would give it a try |
| 14:47 |
maholtz|WORK |
hm... and compare database says everything is fine? |
| 14:48 |
maholtz|WORK |
did you installed extension phpmyadmin and tried there? |
| 14:48 |
FloLeBlanc |
hi all |
| 14:48 |
FloLeBlanc |
did someone ever experience a similar error when setting up the cronjob for directmail? <b>Warning</b>: require_once(//t3lib/class.t3lib_div.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream |
| 14:49 |
gerards |
maholtz|WORK: Denyerec asked WinstonS to compare. I guess it should be ok. |
| 14:49 |
FloLeBlanc |
I guess there's one slash too many, but how do I remove that one without hacking the code |
| 14:50 |
gerards |
WinstonS: there seems to be some kind of patch for Suhosin for Typo3. does it apply to you? |
| 14:50 |
WinstonS |
i'm going to install phpmyadmin. what especially should i check? |
| 14:51 |
WinstonS |
gerards, dunno. the thread i found was from 2007 |
| 14:51 |
gerards |
just check that you can write to the pages table form phpmyadmin. |
| 14:52 |
gerards |
WinstonS: I really think its suhosin fooling around with the php code (i don't think the DB connection / privileges are the problem). |
| 14:53 |
gerards |
but I don't have any experience with suhosin, so I'm just blaming the unknown. :) |
| 14:55 |
Denjerek |
Who's suosin |
| 14:55 |
Denjerek |
? |
| 14:55 |
gerards |
http://www.hardened-php.net/suhosin/ |
| 14:56 |
gerards |
oops bbl |
| 14:56 |
gerards |
if someone solves this, can someone PM me the solution? I'm pretty curious now.... |
| 15:02 |
WinstonS |
i removed suhoshin by now. no change |
| 15:05 |
WinstonS |
strange enough, phpmyadmin just says "no change" |
| 15:06 |
WinstonS |
when trying to insert something into the "page" table |
| 15:06 |
Denjerek |
So you basically can't modify the DB |
| 15:06 |
Denjerek |
can you dump the perms from the pages table ? |
| 15:06 |
Denjerek |
Not the DB |
| 15:06 |
Denjerek |
just the pages tabe |
| 15:06 |
Denjerek |
table |
| 15:08 |
BejjWrk |
Im having this odd issue with rtehtmlarea not loading on one server, but works fine with the site replicated to another server |
| 15:08 |
BejjWrk |
any ideas ? |
| 15:10 |
Denjerek |
caches? |
| 15:10 |
WinstonS |
file permissions? |
| 15:10 |
WinstonS |
Denjerek, according to the cli it's all privileges on database.* |
| 15:11 |
BejjWrk |
caches are cleared, file permissions ok according to installtool |
| 15:12 |
BejjWrk |
and ofc the sysadmin of the remote server is a duce and i have to set permissions via ftp. |
| 15:13 |
WinstonS |
which php mysql module does typo3 need? mysql, mysqli or pdo_mysql? |
| 15:13 |
WinstonS |
define "not loading" |
| 15:14 |
BejjWrk |
not loading as in: "The editor is being loaded, please wait..." and nothing happens. |
| 15:16 |
WinstonS |
hm |
| 15:17 |
WinstonS |
i'd check the differences between the two boxes. different web server, php versions, etc |
| 15:17 |
BejjWrk |
im gonna upload the sourcefiles for 3rd time, if it still doesnt work i blame the sysadmin |
| 15:19 |
Denjerek |
nono winston |
| 15:19 |
Denjerek |
on the _table_ |
| 15:19 |
Denjerek |
if I browse my DB with navicat there are distinct privs for a database, and for each table |
| 15:19 |
WinstonS |
shouldn't .* mean "all tables", or am i mistaken? |
| 15:19 |
Denjerek |
It will |
| 15:19 |
Denjerek |
so long as nothing below that overrides it |
| 15:19 |
Denjerek |
think like CSS specificity |
| 15:20 |
WinstonS |
true |
| 15:20 |
Denjerek |
It's worth checking. |
| 15:20 |
WinstonS |
hm. does phpmyadmin display this somewhere? |
| 15:20 |
WinstonS |
never noticed so far |
| 15:20 |
Denjerek |
I used navicat lite |
| 15:20 |
Denjerek |
(It's free) |
| 15:21 |
Denjerek |
hmm |
| 15:21 |
Denjerek |
seems I might be wrong |
| 15:21 |
Denjerek |
nothing unusual there |
| 15:22 |
Denjerek |
ah |
| 15:22 |
Denjerek |
no I am riht |
| 15:22 |
WinstonS |
cant install navicat. no gui on the dev box |
| 15:22 |
Denjerek |
you can manage privs with navicat lights |
| 15:22 |
Denjerek |
Connect from your windows machine ? |
| 15:22 |
Denjerek |
that's what I do |
| 15:23 |
Denjerek |
you just have to make sure mySQL is listening to your windows machine IP |
| 15:23 |
WinstonS |
they're on seperated nets, cant reach it :/ |
| 15:23 |
Denjerek |
ack |
| 15:23 |
Denjerek |
lemme check PHPMyadmin |
| 15:23 |
WinstonS |
thank you |
| 15:24 |
Denjerek |
yes |
| 15:24 |
Denjerek |
ok |
| 15:24 |
Denjerek |
PHP MYadmin |
| 15:24 |
Denjerek |
privs |
| 15:24 |
Denjerek |
(From homepage) |
| 15:24 |
Denjerek |
select user |
| 15:24 |
Denjerek |
click edit pencil |
| 15:24 |
Denjerek |
Then you should see halfway down "Database specific privs" |
| 15:25 |
Denjerek |
See anything ? |
| 15:33 |
maholtz|WORK |
re |
| 15:36 |
Denjerek |
re ? |
| 15:36 |
Denjerek |
I was asking if WinstonS could see anything in his PHPMyadmin permissions view |
| 15:40 |
WinstonS |
looks like i'm stupid. i dont even find the pencil icon :/ |
| 15:47 |
WinstonS |
gah. cant even login as root with empty password. in spite of changing the phpmyadmin config |
| 15:51 |
WinstonS |
found it. no table specific permissions. |
| 15:51 |
WinstonS |
all perms on the typo3 database |
| 15:55 |
WinstonS |
do i need to install a template before being able to create pages? |
| 16:06 |
maholtz|WORK |
@WinstonS: nope |
| 16:07 |
Denjerek |
nope,. |
| 16:07 |
Denjerek |
Usually you create a page, then attach the template to it. |
| 16:07 |
Denjerek |
WinstonS: can you try and install an extension ? |
| 16:08 |
Denjerek |
go to the extension manager, update, then search for seo_basics |
| 16:08 |
Denjerek |
Try and install it |
| 16:08 |
Denjerek |
see if you receive any errors. |
| 16:10 |
WinstonS |
Denjerek, i just installed templavoila and messing around with it |
| 16:10 |
WinstonS |
it at least created a page tree |
| 16:10 |
WinstonS |
now i'm messing with mapping and data objects |
| 16:11 |
Denjerek |
ooh |
| 16:11 |
WinstonS |
templavoila + some free template -> page tree created |
| 16:11 |
Denjerek |
Well you needed templatevoila anyway |
| 16:11 |
Denjerek |
for FTB |
| 16:11 |
Denjerek |
:) |
| 16:11 |
Denjerek |
But still... |
| 16:11 |
Denjerek |
come to think of it, I've never NOT used TV |
| 16:11 |
Denjerek |
So perhaps I would be unable to make a pagetree too ? |
| 16:11 |
WinstonS |
heh |
| 16:12 |
Denjerek |
Although... I've never used the free templates |
| 16:12 |
Denjerek |
what's the name of that TV setup that kickstarts a whole site |
| 16:12 |
Denjerek |
has a load of widgets and modifications to the backend |
| 16:12 |
WinstonS |
it's just to mess around, getting used and bugfix. i'll have to create a own template later on too |
| 16:12 |
WinstonS |
no idea. i just found templavoila in some tutorial |
| 16:13 |
Denjerek |
Probably FTB |
| 16:13 |
Denjerek |
it's a great way to work IMo |
| 16:13 |
Denjerek |
Gnn |
| 16:13 |
Denjerek |
maholtz do you rememeber the name ? |
| 16:13 |
Denjerek |
There is a site... and an extension i think |
| 16:14 |
Denjerek |
And it generates a load of flexible content components and changes some BE things. |
| 16:14 |
maholtz|WORK |
busy nogging? |
| 16:15 |
maholtz|WORK |
http://templavoila.busynoggin.com/ |
| 16:20 |
Denjerek |
Busynoggin! |
| 16:20 |
Denjerek |
Thankyou maholtz that was driving me crazy |
| 16:22 |
Denjerek |
You'll be doing a lot of that. |
| 16:22 |
Denjerek |
:) |
| 16:23 |
Loaden |
hello, does somebody know where i can change the domain of a site in typo? |
| 16:28 |
Denjerek |
Um |
| 16:28 |
Denjerek |
Well |
| 16:28 |
Denjerek |
you can check for domain records int he list view |
| 16:29 |
Denjerek |
and you can look in the template->setupup for the site.baseURL= line |
| 16:29 |
Denjerek |
config.baseURL |
| 16:29 |
Denjerek |
sorry |
| 16:33 |
WinstonS |
still reading busy noggin and messing around with templatevoila. thank you for your hints, guys |
| 16:40 |
Denjerek |
No worries WinstonS, just be sure to idle here. |
| 16:40 |
Denjerek |
Familiar names get more attention :) |
| 16:41 |
Denjerek |
(it's like fight club... gotta stand out in the rain for 3 days...) |
| 16:48 |
WinstonS |
*lol* except you talk more about this fight club |
| 16:57 |
Denjerek |
ggrmble |
| 16:57 |
Denjerek |
bloody connection |
| 17:00 |
WinstonS |
wb |
| 17:01 |
Loaden |
thx @Denjerek |
| 17:02 |
Loaden |
bb |
| 17:02 |
Denjerek |
Did you fix it Loaden ? |
| 17:02 |
Loaden |
yes, works fine |
| 17:08 |
WinstonS |
i just noticed the following, while messing with tempovola and busy noggin: |
| 17:09 |
WinstonS |
create database, create user, grant all on database to user; installtool: import db. no errors, but no page tree. |
| 17:10 |
WinstonS |
drop database; install tool: create database (same name), import db: no errors, page tree created. |
| 17:18 |
Denjerek |
How very curious |
| 17:19 |
Denjerek |
Wait |
| 17:19 |
Denjerek |
Winston are you just doing the same procedure twice |
| 17:19 |
Denjerek |
or are you doing one from the 123 tool, and one from the backend Install Tool |
| 17:19 |
Denjerek |
? |
| 17:20 |
WinstonS |
i followed the instructions from the busy noggin website |
| 17:20 |
WinstonS |
while messing around with the 123 tool i am not logged in to the backend |
| 17:21 |
WinstonS |
still the backend seems to not being able to update the database |
| 17:21 |
WinstonS |
i cant modify the template |
| 17:21 |
Denjerek |
it really does seem as if, once beyond the installation, you don't have write privs. |
| 17:21 |
WinstonS |
yep, by the looks of it. |
| 17:22 |
Denjerek |
did you create two SQL users? |
| 17:22 |
Denjerek |
localhost and 127.0.0.1 ? |
| 17:22 |
WinstonS |
but i dont get the slightes hint of an error |
| 17:22 |
WinstonS |
yeah, but grant all for both |
| 17:22 |
Denjerek |
hrmph. |
| 17:22 |
WinstonS |
and using "localhost" in localconf |
| 17:22 |
WinstonS |
localhost / 127.0.0.1 IS a difference to mysql. |
| 17:23 |
WinstonS |
localhost usually uses a UNIX socket, 127.0.0.1 uses tcp networking. |
| 17:23 |
Denjerek |
Yeah |
| 17:24 |
Denjerek |
I just wondered if you had one and not the other |
| 17:24 |
Denjerek |
and your config was trying to use the one you didn't have :) |
| 17:24 |
WinstonS |
if this continues i'll try to revert to mysql 5.0 |
| 17:24 |
WinstonS |
mysql 5.1 is quite a mess |
| 17:24 |
Denjerek |
Let me see what I am running on cfaccessories.com |
| 17:24 |
Denjerek |
moment. |
| 17:26 |
Denjerek |
PHP Version 5.2.6 |
| 17:27 |
Denjerek |
5.0.16 |
| 17:27 |
Denjerek |
(mysql 5.0.16) |
| 17:27 |
Denjerek |
MySqli 5.0.16 |
| 17:28 |
WinstonS |
hmhmm |
| 17:28 |
WinstonS |
i dont especially like the 5.1 release anyways. was released in quite a hurry. |
| 17:28 |
Denjerek |
Yes, project management at MySQL since the Sun machinations has been.... odd. |
| 17:28 |
Denjerek |
Can you easily rollback to 5.0.x and test? |
| 17:28 |
WinstonS |
indeed |
| 17:29 |
Denjerek |
Where are you located geographically BTW ? |
| 17:29 |
WinstonS |
yep, and will do that tomorrow. it's only a dev box, i can mess on that one whatever i like ;) |
| 17:29 |
WinstonS |
south western of germany. |
| 17:29 |
Denjerek |
Anywhere near Trier? |
| 17:29 |
Denjerek |
Or more south? |
| 17:32 |
WinstonS |
http://maps.google.co.uk/maps?f=q&source=s_q&hl=de&geocode=&q=neustadt+%2F+weinstrasse&sll=53.800651,-4.042969&sspn=13.679199,31.376953&ie=UTF8&hq=&hnear=Weinstra%C3%9Fe,+67434+Neustadt+an+der+Weinstra%C3%9Fe,+Rheinland-Pfalz,+Deutschland&ll=49.724479,9.206543&spn=1.867928,6.015015&z=8 |
| 17:32 |
WinstonS |
around here ;) |
| 17:32 |
WinstonS |
it's quite a bit to trier |
| 17:33 |
WinstonS |
whassup with trier? |
| 17:37 |
WinstonS |
gotto go. |
| 17:37 |
WinstonS |
thank you, and see you around :) |
| 18:36 |
ndee |
in a rootmenu, how can I change the last item, so that it's not linked? |
| 22:18 |
pulponair |
hi there |
| 22:18 |
pulponair |
anyone in here from norway by any chance? |
| 22:21 |
Prot0 |
pulponair: |
| 22:22 |
Prot0 |
type /who #typo3 *.no |
| 22:22 |
Prot0 |
;] |
| 22:42 |
Notschko |
Hello... |
| 22:43 |
Notschko |
I've got a problem I don't know at all to solve |
| 22:44 |
Notschko |
I need to create a menu that contains random pictures of an given directory |
