| 08:55 |
kevke |
Good morning boyz and girlz. I am in the need of an extension that plays .f4v I have the flowplayer installed, but for some reason it prompts a TYPO3 Fatal Error: Extension key "div" was NOT loaded! (t3lib_extMgm::extPath) and the page is not loaded. Any ideas, or extensions know, that work? |
| 08:59 |
rawtaz |
kevke: i dont know, but maybe that extension is one that uses the "lib/div" mvc framework thingie? see http://wiki.typo3.org/index.php/MVC_Framework |
| 09:00 |
rawtaz |
and that lib/div isnt installed, or something |
| 09:04 |
kevke |
hmm... checking |
| 09:06 |
MESeidel |
just search for it in the ext manager |
| 09:06 |
MESeidel |
should be: Static Methods for Extensions ( div ) |
| 09:14 |
FloLeBlanc |
hi all |
| 09:14 |
maholtz|WORK |
morning |
| 09:15 |
FloLeBlanc |
can someone link me to info or tell me how to fix the <link> problem when my hyperlinks get translated like that from the RTE? |
| 09:16 |
maholtz|WORK |
@FloLeBlanc: in DB there should be <link> the RTE parses that and transforms it to <a> and with saving back to <link> |
| 09:16 |
rawtaz |
hello |
| 09:16 |
FloLeBlanc |
maholtz: well my RTE seems not to do that :) |
| 09:17 |
maholtz|WORK |
did you alter the RTE-settings? |
| 09:17 |
maholtz|WORK |
what happens if you deactivate the RTE? |
| 09:17 |
maholtz|WORK |
you can insert there <link > by hand. does it work? |
| 09:18 |
FloLeBlanc |
maholtz: oh sorry. my fault. I respecify my question |
| 09:18 |
rawtaz |
maholtz|WORK: regarding what we spoke about yesterday, you said that .php and .inc files can be executed and therefore are not allowed for creation in the file admin. i buy that, but at the same time the file admin where you do this explicitly states that .inc is allowed. |
| 09:18 |
FloLeBlanc |
which TS code do I have to use to let a SELECT get parsed through the RTE |
| 09:18 |
rawtaz |
the context help says "Enter a filename here if you want to create a new text-based file. Notice that it must have one of the endings in the list of text-endings shown above (except "php" endings)." and the suffix list says "[*.txt, *.html, *.htm, *.css, *.tmpl, *.js, *.sql, *.xml, *.csv, *.phpsh, *.inc]" |
| 09:18 |
maholtz|WORK |
@rawtaz: ok, so i am wrong |
| 09:19 |
maholtz|WORK |
@FloLeBlanc: ah, backend is fine, frontend outputs <link>? |
| 09:19 |
maholtz|WORK |
lib.parseFunc_RTE |
| 09:19 |
rawtaz |
not necessarily :) im just thinking it could a little bug or something in the gui |
| 09:19 |
maholtz|WORK |
10 = TEXT |
| 09:19 |
maholtz|WORK |
10.field = bodytext |
| 09:19 |
maholtz|WORK |
10.parseFunc < lib_parseFunc_RTE |
| 09:19 |
FloLeBlanc |
ah thank you |
| 09:20 |
maholtz|WORK |
ouch - typo: < lib.parseFunc_RTE |
| 09:20 |
FloLeBlanc |
hmm does CONTENT have that too? |
| 09:21 |
FloLeBlanc |
http://www.phlogi.net/f/t3/tsp/sp/-50278577e2 is what I have at the moment |
| 09:22 |
kevke |
back to the TYPO3 Fatal Error: Extension key "div" was NOT loaded! (t3lib_extMgm::extPath) issue, how do I know which dependencies must be met prior the prompting extension? |
| 09:24 |
rawtaz |
kevke: doesnt it say if you click on the extension in the extension manager? |
| 09:24 |
rawtaz |
theres a "depends on" field in there |
| 09:25 |
maholtz|WORK |
@kevke: the extension author should have set the dependencies |
| 09:26 |
rawtaz |
kevke: did you try installing the div extension? |
| 09:26 |
maholtz|WORK |
@FloeLeBlanc: just add 10.parseFunc < lib.parseFunc_RTE |
| 09:26 |
maholtz|WORK |
CONTENT just reads content elements and loads it into $this->cObj->data |
| 09:27 |
maholtz|WORK |
field = header is sth. like echo $this->cObj->data['header'] |
| 09:30 |
FloLeBlanc |
sorry I'm a bit puzzled now... I thought TS is a gigantic PHP array, so If I just add box.content.10.parsefunc will I not just get ['10']['parseFunc'] ? |
| 09:30 |
MESeidel |
@kevke I already wrote, quick search in the repository: |
| 09:30 |
MESeidel |
Static Methods for Extensions ( div ) |
| 09:31 |
FloLeBlanc |
ah in renderObj I guess hmm |
| 09:31 |
maholtz|WORK |
@FloLeBlanc: i was missleading |
| 09:31 |
maholtz|WORK |
just copy in the lib.parseFunc_RTE |
| 09:31 |
maholtz|WORK |
see that it works |
| 09:32 |
maholtz|WORK |
if you want to understand go to core class.tslib_content.php |
| 09:32 |
maholtz|WORK |
somewhere in sysext / cms / tslib |
| 09:33 |
FloLeBlanc |
hmm maholtz: as far as I understand there are certain "key entries" in the array that get handled specifically via functions, but it is a bit hard to understand where they can be placed and where they can't :) |
| 09:33 |
FloLeBlanc |
thank you for your help |
| 09:36 |
kevke |
in the ext manager there is nothing show regadring dependencies, however in TER he stated lib 0.1.0-0.1 where do I get the information, wether or not this dependenciy is met? |
| 09:37 |
kevke |
ext manager said: No XCLASS inclusion code found in file "controllers/class.tx_miflowplayer_controller_player.php". in Code warnings, does that have something to do with the missing div extension? |
| 09:38 |
kevke |
if it is mandatory, that is. |
| 09:43 |
kevke |
The div thing was installed btw |
| 09:44 |
rawtaz |
oh |
| 09:48 |
kevke |
does anyone know a substitute to the flowplayer, if I look for f4v I only get that one, but ther must be other players out there, no? |
| 09:52 |
No5251 |
kevke: http://nonverbla.de/blog/2008/09/15/nonverblasterhover/ |
| 10:02 |
FloLeBlanc |
do css files get cached in t3? |
| 10:03 |
FloLeBlanc |
or better... how do I remove the caching? I did clear all cache in the backend but the file still links to an old version |
| 10:06 |
FloLeBlanc |
nvm error in user |
| 10:29 |
milpoer |
hi all. |
| 10:29 |
rawtaz |
hi milpoer |
| 10:30 |
milpoer |
anyone who can tell my how to style the default content element "login form"?? I want to have my own css template, but cannot find anything on the topic :( perhaps a google-no-search-god-enough-virus |
| 10:32 |
kevke |
Interesting... The nonverblaster thingy is according to the website capable to render f4v but it is not shown |
| 10:33 |
No5251 |
kevke: any errors shown in firebug? |
| 10:43 |
PiMB |
Hi all |
| 10:43 |
rawtaz |
hey |
| 10:44 |
PiMB |
Does anybody here know how an extension can set a page to no_cache |
| 10:44 |
PiMB |
I have an extension (not made by me, but I'm debugging it now) |
| 10:44 |
PiMB |
which is a USER ext, and caching is enabled for it. |
| 10:45 |
PiMB |
i've emptied almost the entire pi1 file (back to kickstarter content) |
| 10:45 |
PiMB |
and still the page with the plugin gives me a no_cache is 1 |
| 10:45 |
PiMB |
if I remove the plugin from the page, no_cache = 0 |
| 10:46 |
ironm |
PiMB every extension have some default settings .. you should check the ts within the extension tree |
| 10:49 |
PiMB |
ironm, did that |
| 10:49 |
PiMB |
nothing there :) |
| 10:49 |
PiMB |
just the normal uncludeLibs and userFunc main call |
| 10:49 |
PiMB |
no additional features |
| 10:50 |
maholtz|WORK |
@PiMB: set_no_cache in there? |
| 10:51 |
PiMB |
nope |
| 10:51 |
kevke |
Has anyone a working f4v to flv converter? |
| 10:52 |
ironm |
kevke: I don't use it myself |
| 10:52 |
maholtz|WORK |
@PiMB: pi_USER_INT_obj=1 ? |
| 10:52 |
PiMB |
No, non of those |
| 10:57 |
PiMB |
I've completely emptyed the main function it has 1 line return 'empty content for nocache testing'; |
| 10:57 |
PiMB |
and still it gives me no_cache = 1 |
| 10:57 |
PiMB |
it's driving me nuts :) |
| 10:57 |
PiMB |
no xclassing, no hooks nothing |
| 10:58 |
maholtz|WORK |
addPItoST43 (...., 1) ? |
| 10:58 |
PiMB |
yes, set to 1 |
| 10:59 |
maholtz|WORK |
just create a new cached extension with the kickstarter |
| 10:59 |
maholtz|WORK |
perhaps what you see does not depend on the extension you are debugging |
| 10:59 |
untouh23 |
hi |
| 10:59 |
PiMB |
Yeah, I guess it's located somewhere else, but it's strange that it's loaded with the extension |
| 10:59 |
maholtz|WORK |
and check page-cache table, perhaps the plugin is not uncached |
| 10:59 |
untouh23 |
i have an 1&1 root server and i just cannot install any extension from the backend ... it says "extension installed successfully" but its not installed |
| 11:00 |
PiMB |
I will |
| 11:00 |
PiMB |
thanks mates |
| 11:00 |
maholtz|WORK |
@PiMB: yep, if you found the solution, please tell me :) |
| 11:00 |
PiMB |
If I find something let you now :) |
| 11:00 |
maholtz|WORK |
:) |
| 11:00 |
untouh23 |
does anyone know what the problem could be |
| 11:00 |
PiMB |
sure thing ;) |
| 11:00 |
untouh23 |
all folders seem to have chmod 777 |
| 11:00 |
Prot0 |
how do you instalL extensions? |
| 11:00 |
maholtz|WORK |
@untouh23: make them 770 |
| 11:00 |
maholtz|WORK |
perhaps suoshin there |
| 11:01 |
untouh23 |
pardon? |
| 11:01 |
untouh23 |
suoshin? |
| 11:01 |
maholtz|WORK |
ups suhosin http://www.hardened-php.net/suhosin/ |
| 11:01 |
untouh23 |
what dirs are important for installing extensions except typo3conf/ext |
| 11:02 |
maholtz|WORK |
typo3conf/localconf.php |
| 11:02 |
untouh23 |
so i will try to set them to 770 |
| 11:02 |
maholtz|WORK |
(well, perhaps it is not related to suhosin, i am not good in server things:) |
| 11:03 |
ironm |
untouh23: if you have ssh-access you could check if the new installed extensions are there .. like "ls -l typo3conf/ext/" .. |
| 11:04 |
untouh23 |
yea they are there |
| 11:04 |
untouh23 |
i see it on my ftp |
| 11:04 |
untouh23 |
theyve been put into that dir |
| 11:04 |
PiMB |
if you go to the typo3conf folder and look at the localconf.php files |
| 11:04 |
PiMB |
which ones do you see? |
| 11:05 |
untouh23 |
theres only one localconf.php file as usual? |
| 11:05 |
PiMB |
what's it's mtime? |
| 11:05 |
untouh23 |
july 8 22:22 |
| 11:05 |
untouh23 |
;) |
| 11:06 |
untouh23 |
should i use my xampp localconf where the exts work and change the db stuff? |
| 11:25 |
rawtaz |
i know there is a list of consultants on the main website, but can someone recommend a swedish consultant? i dont really trust the listing on the site regarding how many sites they made and so on, would prefer to hear from others which ones are good.. |
| 11:25 |
rawtaz |
i am particularly interested in getting in touch with someone who is knowledgable in extension development |
| 11:30 |
FloLeBlanc |
which captcha extension would you recommend for feedback forms? |
| 11:31 |
ironm |
FloLeBlanc: I use sr_freecap |
| 11:32 |
ironm |
FloLeBlanc: however some people complain a bit about the quality of the picture |
| 11:36 |
FloLeBlanc |
hmm ok thx |
| 11:40 |
ZaFantasy |
hi |
| 11:41 |
ZaFantasy |
I want to use some variable in menu TS like wrap = <li>ParentPageTitle</li><li>|</li>... Any tip ? |
| 11:43 |
SargoDarya |
DataWrap |
| 11:43 |
SargoDarya |
or{$varname} |
| 11:43 |
SargoDarya |
as far as i know |
| 11:46 |
milpoer |
rawtaz, what about danes ?? |
| 11:46 |
rawtaz |
milpoer: who/url? =) |
| 11:46 |
milpoer |
netimage.dk |
| 11:46 |
rawtaz |
oh doh, danes as in danish |
| 11:46 |
milpoer |
yes :) |
| 11:47 |
rawtaz |
milpoer: it was mostly the language, would like to talk to them irl and you know how well we swedes understand danish =D |
| 11:47 |
rawtaz |
(don't) |
| 11:47 |
milpoer |
haha.. i know.. not a problem for me.. |
| 11:48 |
rawtaz |
:) |
| 11:50 |
milpoer |
let me know if you need any help.. i will leave for now.. |
| 11:50 |
rawtaz |
milpoer: i will keep you in mind, trying to find a swede primarily though :) |
| 11:50 |
rawtaz |
id need to chat on the phone for a couple or hours or so |
| 11:50 |
rawtaz |
pretty simple |
| 11:50 |
milpoer |
ok :) |
| 11:51 |
milpoer |
good luck |
| 11:51 |
rawtaz |
danke :) |
| 12:28 |
lindbergh |
hello people |
| 12:28 |
rawtaz |
hi |
| 12:29 |
lindbergh |
anyone have idea how to implement search autocomplete option in typo3....beside Solr solution...any similar implementations? |
| 12:32 |
SargoDarya |
I thought there already is one available? |
| 12:33 |
SargoDarya |
http://typo3.org/documentation/document-library/extension-manuals/cb_indexedsearch_autocomplete/current/ |
| 12:58 |
PiMB |
@maholtz|WORK figured a bit out. |
| 12:58 |
PiMB |
I'm missing chashes. |
| 12:58 |
PiMB |
not sure why these aren't created.. |
| 13:24 |
lindbergh |
thank you SargoDarya |
| 13:24 |
SargoDarya |
no problem. Did it work? |
| 13:26 |
maholtz|WORK |
@PiMB: sounds strange (the caching issue) |
| 13:27 |
PiMB |
yeah |
| 13:27 |
lindbergh |
at the moment I just making survey |
| 13:27 |
PiMB |
I suddenly noticed the lack of cHashes, while the extension is just using 01pi_getPageLink so it should be default |
| 13:28 |
PiMB |
for a moment I figured realurl was the problem. |
| 13:28 |
PiMB |
but it's not. |
| 13:59 |
FloLeBlanc |
can you recommend a forum? |
| 14:00 |
FloLeBlanc |
sorry a forum extension of course :) |
| 14:02 |
ironm |
FloLeBlanc: mm_forum |
| 14:02 |
FloLeBlanc |
doesn't that still suffer from bugs? |
| 14:03 |
ironm |
salut atmos4 .. I didn't test it until now ... hopefully the next days |
| 14:04 |
atmos4 |
ironm: OK |
| 14:06 |
atmos4 |
ironm: I've done some work on the upload progress int he meantime, it's not yet integrated into zf_filespender, but pretty cool stuff: http://atmosfear.nctec.net/dev/misc/ulprogress/ulprogress.php |
| 14:06 |
atmos4 |
it will require uploadprogress or APC cache extension for php though |
| 14:07 |
ironm |
hmm |
| 14:07 |
atmos4 |
it's pretty trick, the form gets posted to an hidden iframe, so the page doesn't block |
| 14:07 |
atmos4 |
try uploading eg a 5 mb file |
| 14:08 |
ironm |
atmos4: I can only test what you have sent me within the t3x file |
| 14:08 |
atmos4 |
yea, I meant the link I posted |
| 14:09 |
atmos4 |
it's just a minimal implementation of the stuff I need for the upload progress to be shown |
| 14:10 |
ironm |
atmos4: I have got it |
| 14:22 |
tmkd_ |
hi, how can i change default title of CATMENU? |
| 14:22 |
tmkd_ |
from category to for example 'realisations' |
| 14:33 |
FloLeBlanc |
is there a good alternative to "direct_mail_subscription" when using "direct_mail" ? |
| 14:34 |
PiMB |
you could use powermail |
| 14:35 |
FloLeBlanc |
powermail? isn't that for creating a feedback form? |
| 14:36 |
PiMB |
possible |
| 14:36 |
PiMB |
but powermail has the ability to prefill fields and map them to a different table then powermail itself |
| 14:36 |
PiMB |
why do you want to use a different ext? |
| 14:37 |
mapixu |
Query:Can i change the type of a database field even after using kickstater to creat it? Kickstater created a single database fied of type INT for my multiple checkbox. My problem is that i can't insert the values of my checbox after imploding the array values. |
| 14:37 |
SargoDarya |
wow... I just found out IE sucks less if you're going with xhtml strict |
| 14:37 |
FloLeBlanc |
I don't need to use a different one, just asking if this is feasable |
| 14:37 |
FloLeBlanc |
feasible? |
| 14:37 |
FloLeBlanc |
a good choice :) |
| 14:38 |
SargoDarya |
oh lord, why does PHP suck so hard... |
| 14:39 |
SargoDarya |
why is there sometimes an underscore in a function and sometimes not? Seriously... |
| 14:40 |
FloLeBlanc |
PiMB: would I map that to tt_adress then? |
| 14:46 |
PiMB |
FloLeBlanc, for instance yeah :) |
| 14:46 |
PiMB |
not saying it's the easiest way, but it could be an alternative |
| 14:51 |
FloLeBlanc |
another question please.. to translate a language selection box, is static_info_tables_countryname still the way to go with 4.4? |
| 14:53 |
PiMB |
don't know mate |
| 14:58 |
MESeidel |
Have you tried it? - there is no reason to not use a "old" implementation before version 5 (simply said) |
| 15:06 |
atmos4 |
interesting, just gave the new intorductory package a shot |
| 15:06 |
atmos4 |
first thing after install it gives me is 404 error, because of wrong mod_rewrite config =) |
| 15:07 |
atmos4 |
adding RewriteBase /dev/t3example/ fixed things, but that should probably determined automatically by the package |
| 15:20 |
atmos4 |
where are bus in the introductiory package tracked? main tracker or at forge? |
| 15:56 |
aterriblechaos |
woohoo summer ... my brain melts in that heat |
| 15:59 |
rawtaz |
:) |
| 16:07 |
SargoDarya |
aterriblechaos: heat is a major issue here. Productive development stops at 3pm |
| 16:07 |
rawtaz |
SargoDarya: where at? |
| 16:07 |
SargoDarya |
the last 3 hours are like just sitting around sending youtube links |
| 16:07 |
SargoDarya |
munich, germany |
| 16:07 |
rawtaz |
haha |
| 16:07 |
rawtaz |
oh ok |
| 16:07 |
rawtaz |
hm |
| 16:07 |
rawtaz |
doesnt sound that tropical :) |
| 16:07 |
rawtaz |
but i guess youre not used to that heat |
| 16:08 |
SargoDarya |
it's 31°^c |
| 16:08 |
MESeidel |
Well office is still cooler than the car standing on the roadside all the workday long |
| 16:08 |
SargoDarya |
waiting for some rain |
| 16:08 |
rawtaz |
MESeidel: indeed. actually we have had hot weather in sweden too last week, and even though it was hot inside in my apartment it was cooler than outside :) |
| 16:09 |
aterriblechaos |
same here, since an hour i did'nt do much .. 36°, south-tyrol italy |
| 16:10 |
MESeidel |
fridays are the overkill here (Saxony/Germany) because the speedway is full of people traveling sou west ways (bavaria) and the local roads are full of local people avoiding the speedway |
| 16:10 |
SargoDarya |
and you're even more near equator. |
| 16:10 |
SargoDarya |
MESeidel: germany rocks :D |
| 16:11 |
MESeidel |
I always think it would be better for me in sweden (I have no problems with winter days)^^ |
| 16:11 |
SargoDarya |
Girlfriend wants to go to norway |
| 16:12 |
rawtaz |
question: http://typo3.org/extensions/repository/view/mh_phpinclude/current/info/README.txt/ <-- isnt that already possible, using parseFunc (which i have no idea what it belongs to, maybe tt_content or templavoila or sumthn) |
| 16:12 |
MESeidel |
From the limit time of holidays I spend in the north I cant image the cultural differences between the two and the problems coming up^^ |
| 16:12 |
rawtaz |
MESeidel: go for it :) |
| 16:14 |
aterriblechaos |
rawtaz: this extension looks useless, userFunc does the same thing |
| 16:14 |
rawtaz |
aterriblechaos: thanks for verifying that =) |
| 16:14 |
aterriblechaos |
i love summer, just not working in summer .. we have a lot of mountains here, up there it's quite cold but no internet ;) |
| 16:15 |
teppi|work |
berlin 34° .. :-( waiting for rain too .. but nothing in sight |
| 16:16 |
SargoDarya |
i feel like everythings melting away |
| 16:17 |
aterriblechaos |
lets go to the swimming pool, i'll offer a beer :) |
| 16:17 |
MESeidel |
Oh I can also add beer offers^^ |
| 16:23 |
rawtaz |
eh weird. when i click "new content element" in the page, there is nothing under "select the type of..". but if i do clear all caches, and go here again, it works. but if i go there a second time (without saving first), its blank again |
| 16:30 |
MESeidel |
--- Have a nice weekend People and cu on monday ;o) --- |
| 16:35 |
rawtaz |
meh |
| 16:35 |
SargoDarya |
rawtaz: sounds weird to me |
| 16:35 |
rawtaz |
yeah totally |
| 16:36 |
rawtaz |
it COULD be because i installed lumophpinclude, but i dont know because i hadnt added a CE before. and i ve uninstalled the plugin now and cleared all caches and it still acts weird |
| 16:37 |
SargoDarya |
lol |
| 16:38 |
rawtaz |
is there a simple way to clear the entire database to start fresh? |
| 16:39 |
rawtaz |
without having to do a reinstall of everything. i can of course manually truncate the database tables, but im not sure if i can/should truncate all of them if doing so? |
| 16:43 |
SargoDarya |
I think it's possible to do with install tool |
| 16:54 |
teppi|work |
rawtaz, sounds more like a problem with the cached configuration files .. i would deinstall each custom extension one by one and look if the content types appear .. |
| 17:00 |
rawtaz |
teppi|work: ive disabled both modules, there are only System models there now :) and i did clear all caches (the button). |
| 17:01 |
teppi|work |
and they still disappear? |
| 17:01 |
teppi|work |
hm |
| 17:01 |
teppi|work |
weird |
| 17:01 |
rawtaz |
yep :) well they show once after i clear all caches, but if i cancel creation of CE and then try it again its blank :D |
| 17:02 |
rawtaz |
teppi|work: with a totally fresh install, do you know if all tables in the db should be empty or if some of them should have some default records? |
| 17:03 |
teppi|work |
the static_xx tables should have default records .. the others should be empty i think .. |
| 17:03 |
teppi|work |
dunno if some records are written in the install process |
| 17:03 |
rawtaz |
ok |
| 17:04 |
rawtaz |
no errors anywhere either |
| 17:04 |
rawtaz |
maybe i should hack in an E_ALL |
| 17:05 |
rawtaz |
actually i will just start over, and we'll see if it changes anything |
| 17:07 |
TheEternalAbyss |
ok, so I'm trying to install latest version of typo3 |
| 17:07 |
TheEternalAbyss |
I can't access the Install tool |
| 17:08 |
TheEternalAbyss |
I'm trying to do the ENABLE_INSTALL_TOOL deal, but, there's no typo3conf/ directory....I'm confused |
| 17:08 |
rawtaz |
teppi|work: did you download both the typo3_src AND the dummy package? |
| 17:09 |
rawtaz |
i think the latter is what you are missing. but im a noob in this so who knows :) |
| 17:09 |
TheEternalAbyss |
no just the source |
| 17:09 |
rawtaz |
you must fetch the dummy too |
| 17:09 |
TheEternalAbyss |
ugh |
| 17:09 |
teppi|work |
yep |
| 17:09 |
TheEternalAbyss |
i can't use my site? |
| 17:09 |
TheEternalAbyss |
i'm migrating it over |
| 17:09 |
rawtaz |
its the skeleton of the actual site. the source is just the "library" |
| 17:10 |
teppi|work |
you'll have to copy all folders that are not included in the source package |
| 17:10 |
TheEternalAbyss |
i see |
| 17:10 |
TheEternalAbyss |
ok thanks |
| 17:30 |
TheEternalAbyss |
uh...in setting up the db |
| 17:30 |
TheEternalAbyss |
i'm installing it locally first |
| 17:30 |
TheEternalAbyss |
so host: 127.0.0.1 should be used right? |
| 17:31 |
TheEternalAbyss |
i can access the site using 127.0.0.1:4001 tho |
| 17:32 |
TheEternalAbyss |
hmm |
| 17:33 |
rawtaz |
what? =) |
| 17:33 |
rawtaz |
yeah 127.0.0.1 is for localhost, using tcp/ip to connect to the db |
| 17:34 |
TheEternalAbyss |
ok so I'm confused since 127.0.0.1 is my host, the username and password shouldn't be different from what is already defined |
| 17:34 |
TheEternalAbyss |
for that db |
| 17:34 |
TheEternalAbyss |
yet it can't connect :\ |
| 17:34 |
rawtaz |
are you sure the settings are correct? what do the database logs say? |
| 17:35 |
TheEternalAbyss |
where would the logs be? |
| 17:36 |
rawtaz |
is it mysql or postgres? |
| 17:37 |
TheEternalAbyss |
mysql |
| 17:38 |
rawtaz |
it depends on your OS and so on, but its a file called <theHostName>.err |
| 17:38 |
rawtaz |
what OS? |
| 17:38 |
TheEternalAbyss |
windows7 |
| 17:38 |
rawtaz |
ok. then i have no idea. but i would suppo seits under C:/Program Files/mysql/.... if thats where you installed it |
| 17:40 |
rawtaz |
gah wtf is wrong with my apache all of a sudden. it wont follow the symlinks :( |
| 17:41 |
TheEternalAbyss |
hmm.....i didn't set a usernam/pass when I created the db in phpmyadmin.... |
| 17:42 |
TheEternalAbyss |
would that matter? (i didn't see the option at the time) |
| 17:42 |
rawtaz |
TheEternalAbyss: yeah you should give a user access to the database |
| 17:43 |
TheEternalAbyss |
hmm |
| 17:43 |
rawtaz |
when theres a database and the user has access to it with his password, you should be able to connect :) |
| 17:43 |
TheEternalAbyss |
in phpmyadmin i get a error when checking privaleges |
| 17:44 |
TheEternalAbyss |
error #1054 |
| 17:44 |
rawtaz |
ok? |
| 17:45 |
TheEternalAbyss |
unknown column |
| 17:46 |
rawtaz |
which, what, etc. it must surely say more than just "unknown column"? |
| 17:47 |
TheEternalAbyss |
#1054 - Unknown column 'Event_priv' in 'field list' |
| 17:47 |
rawtaz |
interesting |
| 17:47 |
rawtaz |
try refreshing it just to be sure. sounds like phpmyadmin and the mysql tables doesnt sync for some reason |
| 17:48 |
TheEternalAbyss |
well |
| 17:48 |
TheEternalAbyss |
i fooudn th euser overview tho |
| 17:48 |
TheEternalAbyss |
found* |
| 17:48 |
rawtaz |
otherwise you can do it in the console/mysql client prompt |
| 17:48 |
rawtaz |
oh, can you fix it there ten? |
| 17:48 |
rawtaz |
then* |
| 17:49 |
TheEternalAbyss |
is my db password the same as my phpmyadmin user/pass? |
| 17:49 |
rawtaz |
doesnt have to be |
| 17:49 |
rawtaz |
your phpmyadmin user/pass can be anything, but by default i would guess that you log into pma using root/somepassword |
| 17:50 |
TheEternalAbyss |
i'm so confused... |
| 17:50 |
TheEternalAbyss |
lol |
| 17:50 |
rawtaz |
what you want to do for typo3 is 1) create a database for it, 2) create a user and give it access to that database |
| 17:50 |
rawtaz |
yeah :) |
| 17:50 |
rawtaz |
youre not alone |
| 17:50 |
rawtaz |
acutally can you get to the mysql console instead? |
| 17:50 |
rawtaz |
or is this on a remote host where you dont have console access |
| 17:51 |
TheEternalAbyss |
it's localhost, but once i confirm everything works here, I'll be putting it up on my host server |
| 17:51 |
TheEternalAbyss |
well I can access the db now |
| 17:51 |
TheEternalAbyss |
i don't like that error in privaleges tho... |
| 17:52 |
rawtaz |
nah |
| 17:53 |
rawtaz |
what version of mysql and pmga? |
| 17:53 |
rawtaz |
pma* |
| 17:53 |
TheEternalAbyss |
phpma is 3.3.3 |
| 17:53 |
TheEternalAbyss |
mysql uhh....lemme look lol |
| 17:54 |
TheEternalAbyss |
5.1.41 |
| 17:54 |
TheEternalAbyss |
wow my site died on this version of typo3 |
| 17:56 |
TheEternalAbyss |
#1 PHP: Function ereg() is deprecated in C:\....\typo3conf\ext\templavoila\class.tx_templavoila_htmlmarkup.php line 523 |
| 17:56 |
TheEternalAbyss |
templavoila phailed |
| 17:56 |
rawtaz |
yes, ereg is removed. you probably switched to a newer php version as well |
| 17:57 |
rawtaz |
you can install the ereg extension in php to get that problem out of the way |
| 17:57 |
rawtaz |
BUT |
| 17:57 |
TheEternalAbyss |
but? |
| 17:57 |
rawtaz |
i would presume that the later versions of templavoila dont use ereg anymore |
| 17:58 |
TheEternalAbyss |
i dunno. I need to access my backend i think and update templavoila |
| 17:58 |
rawtaz |
anyway just install ereg :) |
| 17:58 |
rawtaz |
yeah |
| 18:02 |
TheEternalAbyss |
oooh yea latest version of templavoila is 1.44, i have 1.37 lol that could be a problem hehe |
| 18:06 |
TheEternalAbyss |
...you can't upload downloaded extensions?? |
| 18:07 |
TheEternalAbyss |
nevermind |
| 18:07 |
TheEternalAbyss |
found it |
| 18:09 |
TheEternalAbyss |
yay my site loads! |
| 18:10 |
rawtaz |
nice |
| 18:10 |
TheEternalAbyss |
first load from clicking preview doesn't make it load right tho |
| 18:10 |
TheEternalAbyss |
once I refresh it all works....weird |
| 18:11 |
TheEternalAbyss |
dammit....ok IE says it has modified the page ti help prevent cross-site scripting |
| 18:11 |
TheEternalAbyss |
wtf? |
| 18:13 |
rawtaz |
what version did you update from? |
| 18:13 |
TheEternalAbyss |
4.2.10 |
| 18:13 |
rawtaz |
ko |
| 18:13 |
rawtaz |
well i have no idea, i havent used typo3 |
| 18:13 |
rawtaz |
maybe it gets better if you update some extensions XD |
| 18:14 |
TheEternalAbyss |
i dunno |
| 18:14 |
TheEternalAbyss |
my page is messed up on first load, i need to click on a link to get it going properly then everything seems to function ok |
| 18:16 |
TheEternalAbyss |
and I get parsing errors wtf |
| 18:17 |
TheEternalAbyss |
unable to modify the parent container element before the child element is closed...? |
| 18:18 |
TheEternalAbyss |
well upgrading to 4.4 didn't fix anything |
| 18:19 |
TheEternalAbyss |
i was hoping the quirks I was running into were related to typo3 4.2.10 |
| 18:19 |
TheEternalAbyss |
i guess not |
| 18:19 |
TheEternalAbyss |
I have no idea now... |
| 18:21 |
atmos4 |
hmm, just figured out how to use the typo3 backend on the ipad |
| 18:21 |
atmos4 |
you have to use two fingers for scrolling |
| 18:21 |
TheEternalAbyss |
argh i hate this cms |
| 18:21 |
atmos4 |
because it uses overflow:auto for scrollbars on divs |
| 18:22 |
TheEternalAbyss |
ok why doe sit not load consistently everytime |
| 18:22 |
TheEternalAbyss |
does it* |
| 18:22 |
atmos4 |
TheEternalAbyss: the parsing error probably means you html structure is wrong |
| 18:22 |
TheEternalAbyss |
(IE specifically) |
| 18:22 |
atmos4 |
eg <p><b>hello world</p></b> |
| 18:23 |
TheEternalAbyss |
yea but I didn't make the structure...typo3 did |
| 18:23 |
TheEternalAbyss |
I just used content elements |
| 18:23 |
atmos4 |
you have an url online? |
| 18:23 |
TheEternalAbyss |
yea |
| 18:24 |
TheEternalAbyss |
one sec |
| 18:25 |
TheEternalAbyss |
http://thierry-technology.com/index.php?id=293 |
| 18:26 |
TheEternalAbyss |
also id 299 and 300 |
| 18:26 |
atmos4 |
TheEternalAbyss: you've hgot quite a lot of errors |
| 18:26 |
atmos4 |
first, stylesheet not found |
| 18:26 |
TheEternalAbyss |
??? |
| 18:26 |
TheEternalAbyss |
wtylesheet not found!? |
| 18:26 |
TheEternalAbyss |
stylesheet* |
| 18:27 |
atmos4 |
Failed to load resource: the server responded with a status of 404 (Not Found) /fileadmin/sys/css/content.css |
| 18:27 |
atmos4 |
ReferenceError: Can't find variable: VarienForm -> missing javascript include? |
| 18:27 |
TheEternalAbyss |
what?? |
| 18:27 |
TheEternalAbyss |
what version of IE are you using? |
| 18:28 |
atmos4 |
Safari 5.0 |
| 18:28 |
TheEternalAbyss |
I only get a parsing error and varienform error |
| 18:28 |
atmos4 |
there are more: Unmatched </script> encountered. Ignoring tag. |
| 18:28 |
atmos4 |
probably reason for the js error |
| 18:28 |
atmos4 |
<h2> is not allowed inside <tbody>. Inserting <h2> before the <table> instead. |
| 18:28 |
atmos4 |
fix your html |
| 18:29 |
atmos4 |
and there's a 500 internal server error, trying to load some resource |
| 18:29 |
atmos4 |
I think main.swf |
| 18:29 |
atmos4 |
and your server send wrong mimetype for png, but that only a warning |
| 18:30 |
TheEternalAbyss |
this is blowing my mind |
| 18:30 |
atmos4 |
you can use Chrom as browser for testing |
| 18:30 |
atmos4 |
it has the same web inspector as safari |
| 18:31 |
TheEternalAbyss |
loads in my safari...wtf |
| 18:32 |
atmos4 |
it loads |
| 18:32 |
atmos4 |
yea, but check the inspector |
| 18:32 |
TheEternalAbyss |
inspector only gives me varienform error |
| 18:33 |
atmos4 |
go to resource tab and enable it |
| 18:35 |
TheEternalAbyss |
i'ms till only getting three errors |
| 18:35 |
TheEternalAbyss |
how in the world are you getting all that |
| 18:35 |
atmos4 |
you have safari 5.0 ? |
| 18:36 |
TheEternalAbyss |
i'm using chrome |
| 18:36 |
atmos4 |
ok, latest development version? older version's inspector is not so advanced yet |
| 18:36 |
TheEternalAbyss |
should be up to date |
| 18:36 |
atmos4 |
you have to use dev channel to get latest version |
| 18:36 |
atmos4 |
should be 6.0 sth |
| 18:37 |
TheEternalAbyss |
says google chrom is up to date |
| 18:37 |
atmos4 |
I'm currently lookinmg at the source to try spot the rrors |
| 18:38 |
TheEternalAbyss |
dev chan? |
| 18:38 |
atmos4 |
yea, there it is |
| 18:38 |
atmos4 |
+ |
| 18:38 |
atmos4 |
you opened html comment in line 53, but didn't close it |
| 18:38 |
atmos4 |
for <!-- <script src="fileadmin/sys/js/slidePics.js" language="javascript"></script> |
| 18:39 |
atmos4 |
change to <!-- <script src="fileadmin/sys/js/slidePics.js" language="javascript"></script> --> |
| 18:39 |
atmos4 |
that should get rid of some errors |
| 18:40 |
TheEternalAbyss |
thanks |
| 18:40 |
TheEternalAbyss |
yes deleted that line |
| 18:40 |
TheEternalAbyss |
don't need it anyways |
| 18:41 |
atmos4 |
and check for the missing stylesheet |
| 18:41 |
TheEternalAbyss |
i don't have a stylesheet called content....at least I don't think i do |
| 18:42 |
TheEternalAbyss |
that's a typo3 issue i think |
| 18:42 |
atmos4 |
no |
| 18:42 |
atmos4 |
typo3 itself doesn*'t include anything from fileadmin/ |
| 18:42 |
atmos4 |
must have been added by you |
| 18:44 |
atmos4 |
it's not referenced in the header, so it must be loader either by @import or by javascript |
| 18:45 |
TheEternalAbyss |
i don't have that file in my css folder....i have no clue lol |
| 18:46 |
TheEternalAbyss |
oh it's in my loader.css |
| 18:47 |
TheEternalAbyss |
wow...why do i have that there... |
| 18:47 |
atmos4 |
yea just found |
| 18:48 |
atmos4 |
btw. you have very inefficient page structure |
| 18:48 |
atmos4 |
laods of resources loaded |
| 18:48 |
atmos4 |
you should use sth like scriptmerger to bring it down to minimum requests |
| 18:48 |
atmos4 |
a good page should not load more than 1 css and 1 js file |
| 18:49 |
atmos4 |
ok, if you need special css for ie there's one more |
| 18:49 |
TheEternalAbyss |
well i removes the reference to content.css and now my page broke lol |
| 18:50 |
TheEternalAbyss |
ok resource tracking crashes my page |
| 18:53 |
atmos4 |
for some reason there is a request to http://thierry-technology.com/undefined |
| 18:54 |
atmos4 |
which tirggers a 500 internal server error |
| 18:54 |
atmos4 |
probably some javascript going wrong |
| 18:54 |
atmos4 |
so a string that should be defined returns undefined |
| 18:54 |
TheEternalAbyss |
i'm not seeing any server error |
| 18:55 |
atmos4 |
you're calling page id 293? |
| 18:55 |
TheEternalAbyss |
yes |
| 18:58 |
atmos4 |
I think the failed request might come from inside main.swf |
| 18:58 |
atmos4 |
it's ot quite trackable |
| 18:58 |
atmos4 |
but I gea a failed to laod resource main.swf |
| 18:58 |
atmos4 |
maybe from withtin the falsh file you try to laod a resource? |
| 18:58 |
atmos4 |
like a config file or sth |
| 18:59 |
TheEternalAbyss |
chrome dies on resource tracking |
| 18:59 |
rawtaz |
oooooooooooooooooooooooookay. i just remade my entire installation of 4.4 and still the new content element view shows me no element types in the first step :( |
| 18:59 |
rawtaz |
unless i clear all caches, after which i get hte view once |
| 19:00 |
TheEternalAbyss |
it just does the Aw Snaps |
| 19:00 |
atmos4 |
rawtaz: try disabling all extensions |
| 19:01 |
atmos4 |
maybe one is incompatible |
| 19:01 |
rawtaz |
atmos4: but only the default system extensions that came with the source are enabled? :) |
| 19:01 |
atmos4 |
if it works with all ext disabled, reenable one by one |
| 19:01 |
rawtaz |
surely i cant diable all of those haha |
| 19:01 |
atmos4 |
hmm that's starnge |
| 19:01 |
rawtaz |
this is a pure clean install |
| 19:01 |
atmos4 |
default ones should work fine |
| 19:01 |
rawtaz |
yeah it must be something with my setup or so |
| 19:01 |
TheEternalAbyss |
ok i think i got it loading at least |
| 19:01 |
rawtaz |
oh well, i DID add a template |
| 19:01 |
rawtaz |
wait ill reset the template |
| 19:02 |
atmos4 |
so you go to a page and click new content elementin second toolobar fromt op? |
| 19:02 |
rawtaz |
atmos4: correct |
| 19:02 |
atmos4 |
and it looks like what? |
| 19:03 |
rawtaz |
i can put an image online |
| 19:03 |
rawtaz |
cuz this is driving me nuts lol |
| 19:03 |
atmos4 |
for me it looks like this: http://grab.by/5sbg |
| 19:04 |
rawtaz |
wow youre fast on the pasting :p |
| 19:04 |
atmos4 |
I have direct upload on screenshot |
| 19:04 |
atmos4 |
I press a shortcut, select screen area and it uploads and give me an url |
| 19:04 |
rawtaz |
lovely |
| 19:04 |
atmos4 |
tinygrab is very handy |
| 19:05 |
rawtaz |
what OS? |
| 19:05 |
rawtaz |
os x |
| 19:05 |
TheEternalAbyss |
i'm still not seeing any internal server errors |
| 19:05 |
atmos4 |
I'm on max ox x snow leopard, but it's available for windows aswell |
| 19:05 |
atmos4 |
argh |
| 19:05 |
atmos4 |
mac os x =) |
| 19:05 |
rawtaz |
atmos4: holy cow, i so want that :D i will check it out asap |
| 19:06 |
atmos4 |
so your page is completely empty when you say new element? |
| 19:06 |
atmos4 |
have you checked php error log? |
| 19:07 |
rawtaz |
yes nothign there |
| 19:07 |
atmos4 |
TheEternalAbyss: well it seems it is caused by the flash file, maybe chrome can't track that |
| 19:07 |
rawtaz |
just a moment, getting tinygrab |
| 19:08 |
TheEternalAbyss |
i dunno. I don't see the error at all |
| 19:08 |
TheEternalAbyss |
i have ot go to a meeting |
| 19:08 |
TheEternalAbyss |
thanks for all the help |
| 19:08 |
TheEternalAbyss |
I'll return...soon i hope lol |
| 19:08 |
atmos4 |
TheEternalAbyss: ok, cya, you shpould check apache access log |
| 19:08 |
atmos4 |
you'll seee the request to /undefined |
| 19:12 |
rawtaz |
atmos4: http://grab.by/5sbJ |
| 19:13 |
atmos4 |
that's strange |
| 19:13 |
rawtaz |
atmos4: to add to that, heres some fun fact.. |
| 19:13 |
atmos4 |
are you in page module? |
| 19:13 |
rawtaz |
yes i am |
| 19:13 |
atmos4 |
are you admin? |
| 19:13 |
rawtaz |
if i now click the back arrow, and then again the create CE button |
| 19:13 |
rawtaz |
i get the same result |
| 19:14 |
rawtaz |
if i do what i just said, but clear all caches while at this page/before leaving it, its the same result |
| 19:14 |
atmos4 |
if you are not logged in as admin, I think your user has no access to these content elements |
| 19:14 |
rawtaz |
BUT, if i clear the cache right before i click the create CE button, i get the contents types |
| 19:14 |
rawtaz |
atmos4: yes i am admin |
| 19:14 |
rawtaz |
atmos4: there are no content elements in there |
| 19:14 |
rawtaz |
its a clean page |
| 19:15 |
atmos4 |
hmm that really looks like some php code is going wrong |
| 19:15 |
rawtaz |
yeah sounds reasonable |
| 19:15 |
atmos4 |
is error loggin enabled in your php? |
| 19:15 |
rawtaz |
yes |
| 19:15 |
rawtaz |
i have it to E_ALL in php.ini |
| 19:16 |
rawtaz |
dunno if typo3 changes that a little maybe |
| 19:16 |
rawtaz |
is tehre anything else than "clean all caches" that i can.. clean? anything temporary/cached/compiled? |
| 19:17 |
atmos4 |
well on a clean new site, what's there to clean? |
| 19:17 |
atmos4 |
theres stuff in typo3temp |
| 19:17 |
rawtaz |
no idea :) someone mentioned configuration cache earlier |
| 19:17 |
atmos4 |
can you paste your root template ts code to paste.phlogi.net? |
| 19:18 |
atmos4 |
although that shouldn't really interfere with backend |
| 19:18 |
atmos4 |
you have any page tsconfig? |
| 19:18 |
rawtaz |
you do mean the one i see when i go to Web->Template, the root page, and modify the template, in the setup and constants section? |
| 19:19 |
atmos4 |
yea that's your root ts template |
| 19:19 |
atmos4 |
and page ts config, is when you edit a page and paste ts into the tsconfig filed on advanced tab |
| 19:19 |
rawtaz |
http://grab.by/5scc and http://grab.by/5scf |
| 19:19 |
rawtaz |
(this is truly handy dandy) |
| 19:19 |
rawtaz |
ah, i see |
| 19:20 |
rawtaz |
there is nothing in the page's ts config |
| 19:21 |
rawtaz |
it seems that typo3 has lowered the error reporting. maybe i should try to have it raised |
| 19:21 |
rawtaz |
local value: 6135, default value: 6143 |
| 19:22 |
atmos4 |
I think it can be modified in install tool |
| 19:23 |
rawtaz |
true |
| 19:24 |
atmos4 |
there's an option displayErrors |
| 19:24 |
rawtaz |
ill turn that on too :3 |
| 19:25 |
rawtaz |
ah crap it doesnt load now lol. possibly because i set exceptionalErrors to an invalid value |
| 19:26 |
atmos4 |
yea leave that |
| 19:26 |
atmos4 |
instead try looking at admin tools -> log module |
| 19:26 |
atmos4 |
and set Action: to Errors |
| 19:26 |
rawtaz |
btw, should i mention that im running on postgres? shouldnt matter i suppose but still |
| 19:26 |
rawtaz |
ok, done |
| 19:26 |
rawtaz |
nothing there |
| 19:26 |
rawtaz |
ill try the page thingie again |
| 19:27 |
atmos4 |
that's were exceptionalErrors handler will write the info |
| 19:27 |
rawtaz |
i tried creating CE again, still no types shown, the log says nothing of type error, its empty |
| 19:28 |
atmos4 |
clear cache first and retry |
| 19:28 |
rawtaz |
to clarify; i still have exceptionalErrors at typo3's default value, i only raised errorHandlerErrors to the max value |
| 19:28 |
rawtaz |
ok |
| 19:28 |
rawtaz |
i should only have to click "clear all caches", right? |
| 19:29 |
atmos4 |
yea, what you used to do to get the elements to show once |
| 19:29 |
rawtaz |
yeah |
| 19:29 |
rawtaz |
i did, and they showed (the element types under create CE) |
| 19:29 |
rawtaz |
nothing new in the log |
| 19:29 |
atmos4 |
hmm |
| 19:29 |
rawtaz |
i go to the page again, and now they DO show |
| 19:30 |
rawtaz |
without me having cleared caches |
| 19:30 |
rawtaz |
twice now. |
| 19:30 |
rawtaz |
nothing new in the logs. hm |
| 19:30 |
atmos4 |
any info about your enviroment? webserver, php and mysql version? |
| 19:30 |
rawtaz |
something is just flaky |
| 19:31 |
rawtaz |
os x 10.6, though running apache and php via pkgsrc (not the OS's ones). its php 5.2.10, typo3 4.4, postgresql 9 |
| 19:32 |
atmos4 |
hmm postgre as db |
| 19:32 |
atmos4 |
that could be a hint |
| 19:32 |
atmos4 |
I don't know postgre, but can you enable query log? |
| 19:32 |
rawtaz |
the only difference between now and when it didnt work is that we changed the errorHandlerErrors to max value, and that i cleared cache twice (which i have done before though) |
| 19:33 |
atmos4 |
maybe there's a problem with the generated sql syntax |
| 19:33 |
atmos4 |
most people run typo3 on mysql |
| 19:33 |
rawtaz |
yes i can enable query logs |
| 19:33 |
rawtaz |
i guess i have to get this to fail again though, for it to be useful :) |
| 19:33 |
rawtaz |
but the fact that when it doesnt work, i have to clear cache *right before* going to create CE does carry some type of importance i think. should be analyzed :) |
| 19:34 |
rawtaz |
let me try to lower the error setting again |
| 19:35 |
atmos4 |
I'd check the query log for errors |
| 19:35 |
rawtaz |
eh, its at their default. wtf |
| 19:35 |
atmos4 |
if it doesn't happen after clearing cache, it must happen at fetching from db |
| 19:35 |
rawtaz |
atmos4: but right now it works, i get hte CE types. do you still think i should check the logs for the db? |
| 19:35 |
atmos4 |
because at first call data is displayed directly, at second it's fetched fromd b |
| 19:35 |
atmos4 |
rawtaz: if you can reproduce it, check the logs |
| 19:36 |
rawtaz |
sounds reasonable |
| 19:36 |
rawtaz |
yes |
| 19:36 |
atmos4 |
and then make a bug report at bugs.typo3.org |
| 19:36 |
atmos4 |
I guess it's related to postgre vs. mysql syntax differences |
| 19:36 |
rawtaz |
could be.. |
| 19:39 |
rawtaz |
this is crazy |
| 19:40 |
rawtaz |
i lowered the error reporting (errorHandlerErrors) from 6143 to 6135, cleared cache twice, and now its there reproducable again |
| 19:40 |
rawtaz |
on to the query logging then |
| 19:41 |
rawtaz |
atmos4: if you are curious about the continuation of this, will you be here in a couple of hours too? |
| 19:42 |
rawtaz |
i should go get a pizza and then head for the office before i continue |
| 19:42 |
atmos4 |
probably, I'll go back to coding, but I'll get noticed if you write my nick in front of the message |
| 19:42 |
rawtaz |
ok :) |
| 19:43 |
atmos4 |
what irc client are you usning on mac? |
| 19:43 |
atmos4 |
I'm usinfg colloquy, it'spretty nice |
| 19:43 |
rawtaz |
none, i use irssi and bitlbee in a screen on a server |
| 19:43 |
rawtaz |
oh the unpronouncable :-) |
| 19:43 |
atmos4 |
well give colloquy a shot, pretty nice and free |
| 19:44 |
atmos4 |
http://colloquy.info/ |
| 19:44 |
rawtaz |
looks nice. similar to adium afaict |
| 19:44 |
rawtaz |
do you kow how much tinygrab costs for premium? i cant find it on the site :p |
| 19:45 |
rawtaz |
at |
| 19:45 |
rawtaz |
10 pounds |
| 19:45 |
rawtaz |
totally worth it :D |
| 19:45 |
atmos4 |
hmm I got it for free |
| 19:45 |
rawtaz |
thank you for that tip |
| 19:45 |
atmos4 |
was in one of the last macheists |
| 19:45 |
rawtaz |
oh, thats great :) |
| 19:45 |
rawtaz |
well im off to food, ttyl |
| 19:46 |
atmos4 |
cya |
| 19:59 |
pond |
anyone know why some tables allow a new extension to link the in a db relaiton... and not others? |
| 20:01 |
atmos4 |
you mean in the kickstarter? |
| 20:01 |
pond |
yes |
| 20:03 |
pond |
(I can't believe anyone even tried to answer that question... it was just my way of saying, "good day, here is yet another inexplicable part of typo3 for you all to ponder, how are you today?) |
| 20:04 |
atmos4 |
;-) |
| 20:05 |
atmos4 |
I'm not really sure, but it might be defined in ext_tables.php or tca.php |
| 20:05 |
atmos4 |
haven't worked with the quickstarter for a while |
| 20:06 |
pond |
yeah.. I think so... I think its actually a field that the kickstarter can add to a table... just wonder why... |
| 20:09 |
atmos4 |
it doesn't really matter once you created the extension |
| 20:09 |
atmos4 |
because you can access any table then |
| 20:09 |
atmos4 |
certainly kickstarter wouldn't show tables that aren't registere in tca |
| 20:10 |
atmos4 |
eh. if yoiu just create a new table int he db it wouldn't show up |
| 20:10 |
pond |
yeah... haha... actually, looking at the kickstarter code, it appears that the ones listed are hard coded |
| 20:10 |
atmos4 |
man, my keyboard skills really lack today =) |
| 20:10 |
pond |
mine too.. lol |
| 20:11 |
pond |
I guess it was just a list of tables that were known to be in all installs |
| 20:12 |
atmos4 |
hmm I just looked at it in kickstarter |
| 20:13 |
atmos4 |
by default it only list the main tables that contain content |
| 20:13 |
atmos4 |
but you can choose to enter custom table |
| 20:13 |
pond |
right... |
| 20:13 |
pond |
I thought those tables were pulled automaticaly based on some intrinsic criteria... and wondered what that was... |
| 20:18 |
atmos4 |
I guess the tables will have to have an uid field, because there seems to be no way to select on which column to make the relation |
| 20:19 |
pond |
fortunately I am working witn t_addres... so I'm safe |
| 20:19 |
pond |
tt_address |
| 20:19 |
atmos4 |
yea normal typo3 extension table should always have uid field |
| 20:19 |
atmos4 |
otherwise list module couldn't really work to manage records |
| 20:21 |
TheEternalAbyss |
and i'm back. Ok, time for debugging and code cleaning |
| 20:22 |
pond |
I'll send mine right over, thanks |
| 20:22 |
pond |
I bet that would be a great service... code debugging |
| 20:23 |
TheEternalAbyss |
i'd hire someone to do it for me that's for sure lol |
| 20:23 |
pond |
I bet a lot of people would, actually |
| 20:24 |
atmos4 |
nothing like spending one hour writing code, and 5 hours trying to figure out why it doesn't work ;-) |
| 20:25 |
pond |
eehhhhh... that's not that funny |
| 20:26 |
atmos4 |
yea, had quite of that this week, when I transfered an ext from dev to production server |
| 20:26 |
TheEternalAbyss |
lol atmos4, so true |
| 20:26 |
atmos4 |
it was sending a download after a post request, so it was doing quite some protocol level stuff |
| 20:27 |
atmos4 |
and the production server had lots of stuff interfering, like output buffering and compression, mod_security2 and other stuff I forgot |
| 20:27 |
pond |
ouch |
| 20:27 |
atmos4 |
so there were several factory which made it not work, which made it a lot harder to find the actual problem |
| 20:33 |
TheEternalAbyss |
how can an image return a mime type of html/text? |
| 20:35 |
TheEternalAbyss |
it's just a warning, but still it's weirding me out lol |
| 20:37 |
TheEternalAbyss |
bah i'm getting an error in prototype.js. but I didn't code it so i dunno how to fix it |
| 20:58 |
TheEternalAbyss |
atmos4..can you try and check this for me? http://thierry-technology.com/index.php?id=167 chrome "Aw Snap!", but when I validate it, i get no errors |
| 20:58 |
TheEternalAbyss |
I'm wondering if it acts the same for you |
| 20:59 |
TheEternalAbyss |
ok it loaded now...weird |
| 21:00 |
atmos4 |
no problem here |
| 21:00 |
TheEternalAbyss |
thanks |
| 21:00 |
TheEternalAbyss |
maybe chrome was ust being silly |
| 21:54 |
rawtaz |
atmos4: well i do have logs now of all statements that goes on when it works and when it doesnt work |
| 21:55 |
rawtaz |
ill fetch a second pair of logs from when it doesnt fail at all (after adjusting the error level) |
| 22:03 |
atmos4 |
rawtaz: did you get failed queries? |
| 22:05 |
rawtaz |
no, none. however when the error level is raised there's a TON more queries going on |
| 22:05 |
rawtaz |
if you want i can put them online? |
| 22:06 |
rawtaz |
i mean the log snippets for each try |
| 22:07 |
atmos4 |
no, no time to analyze that |
| 22:07 |
rawtaz |
i understand that :) |
| 22:07 |
atmos4 |
my point was to see wether the queires are failing |
| 22:07 |
rawtaz |
mm. unfortunately not :) |
| 22:07 |
atmos4 |
although that should normally raise a php error aswell |
| 22:09 |
atmos4 |
what you could do is try installing mysql and see if it also happens there |
| 22:09 |
rawtaz |
i could |
| 22:09 |
atmos4 |
that way you would have singled out the problem |
| 22:10 |
rawtaz |
to be honest the current "state" of having the error logging raised as a wild long-shot workaround isnt ok because it generates 6700 queries for that simple view. while when the error level is at its default only 111 queries are performed |
| 22:11 |
rawtaz |
well to be honest these are not queries, some of them are queries with multiple lines in the log |
| 22:11 |
rawtaz |
but its crazy :) |
| 22:11 |
rawtaz |
atmos4: yeah you are right |
| 22:13 |
rawtaz |
atmos4: is it true that in the typo3_src folder no files are ever changed? ie that all changes are done in the site's folders |
| 22:13 |
rawtaz |
curious if i can just set up another site now and have it point to the same source folder or if i should set up a second source folder as well |
| 22:14 |
atmos4 |
yea you shouldn't have to touch anything inside typo3 to t3lib dirs |
| 22:15 |
atmos4 |
usuually typo3_Src is a symlink to the sahred typo3 source on your system |
| 22:15 |
rawtaz |
yes, it is |
| 22:15 |
atmos4 |
so when you upgrade to a new typo3 version you just switch the symlink |
| 22:16 |
rawtaz |
im curious whether or not typo3 ever change/write to files under that folder, or if it keeps its hands off it |
| 22:16 |
atmos4 |
it will never write there |
| 22:16 |
atmos4 |
it writes to typo3temp, typo3conf and uploads only |
| 22:16 |
rawtaz |
great |
| 22:17 |
atmos4 |
youn don't even need typo3 dir, unless you wann login to the backend |
| 22:18 |
atmos4 |
so the backend stuff resides in typo3 and the frontend and utility stuff in t3lib |
| 22:18 |
rawtaz |
oh, i see. the typo3 folder is just a shortcut or rather a mean to get to the backend which is at the source folders typo3 |
| 22:19 |
rawtaz |
aha |
| 22:19 |
atmos4 |
it point to typo3_src/typo3 if you use a shared install |
| 22:19 |
atmos4 |
similar to index.php and t3lib |
| 22:19 |
rawtaz |
mm |
| 22:22 |
rawtaz |
there, one mysql db created |
| 22:23 |
rawtaz |
oh |
| 22:23 |
rawtaz |
it uses the old mysql library in php |
| 22:28 |
atmos4 |
btw. if you need apache, php, mysql preconfigured, you can use MAMP |
| 22:28 |
atmos4 |
http://mamp.info/ |
| 22:29 |
atmos4 |
I use a different approach on my system |
| 22:29 |
atmos4 |
I run a virtual machine with debian as the development webserver |
| 22:29 |
atmos4 |
and it has the projects directory on my mac mounted as the webserver root |
| 22:30 |
rawtaz |
i dont have the memory to spare ;7 |
| 22:30 |
atmos4 |
so I can edit files without upload, but have the webserver run as a standalone system |
| 22:30 |
rawtaz |
and since i have so much other custom software as well i try to keep them all under the same umbrella, in this case ive chosen pkgsrc for that |
| 22:30 |
atmos4 |
yea, I've got 16GB so not an issue |
| 22:30 |
rawtaz |
woah! |
| 22:31 |
rawtaz |
its not a laptop i take it? :) |
| 22:31 |
atmos4 |
no macpro 8-core |
| 22:31 |
rawtaz |
monster machine :p |
| 22:31 |
rawtaz |
ooh, nice |
| 22:31 |
atmos4 |
vmware on my old macbook pro with 2GB is no fun |
| 22:32 |
atmos4 |
but on the macpro it rocks |
| 22:32 |
atmos4 |
I have several vms for each IE version, too |
| 22:32 |
rawtaz |
ah :) |
| 22:33 |
atmos4 |
6,7 and 8, no need to bother with anything older these days |
| 22:33 |
rawtaz |
true, true |
| 22:33 |
atmos4 |
I wish I could remove 6 from that list |
| 22:33 |
atmos4 |
it's such a major pain to support |
| 22:33 |
rawtaz |
i dont think itll go away until ppl stop using XP :< |
| 22:33 |
rawtaz |
yeah it sucks |
| 22:33 |
rawtaz |
oh dear lord how it sucks.. |
| 22:33 |
rawtaz |
lol |
| 22:34 |
atmos4 |
yea, but even one of my clients still used it |
| 22:34 |
rawtaz |
maybe one should start a consulting firm with the sole purpose of finishing development where the client need to support IE6. so they can focus on everything else and then you fix that last part :P |
| 22:34 |
rawtaz |
yeah mine too |
| 22:34 |
rawtaz |
in many places |
| 22:34 |
atmos4 |
for the backend |
| 22:34 |
atmos4 |
:-) that can't be fun |
| 22:34 |
atmos4 |
the slowest js engine on earth |
| 22:35 |
rawtaz |
hah |
| 22:35 |
atmos4 |
I told them to get their admin to install ie8 or use chrome/firefox whatever |
| 22:38 |
rawtaz |
may i ask where you work, and what you do? |
| 22:39 |
rawtaz |
i realize this channel is publically logged though.. |
| 22:40 |
atmos4 |
well I work as a freelancer and do mostly typo3 web development |
| 22:41 |
atmos4 |
I'm not getting rich, but it's ok |
| 22:41 |
rawtaz |
i suppose you develop your own extensions and stuff too, not just using typo3 and existing mods etc to design/build the sites? |
| 22:42 |
atmos4 |
yes, although I don't need to develop own extensions often |
| 22:42 |
atmos4 |
it's quite expensive to develop a new ext, better to see what you can do with existing extensions |
| 22:42 |
atmos4 |
# |
| 22:42 |
atmos4 |
or maybe enhance an existing extension |
| 22:42 |
rawtaz |
yeah sure |
| 22:43 |
rawtaz |
why is it that typo3 is so big in germany of all countries? does it have to do with the general openness to OSS ? |
| 22:44 |
atmos4 |
not quite sure, but for one think a large part of the developer base is from germany |
| 22:44 |
rawtaz |
mhm.. and why would that be? its from denmark originally i recall |
| 22:44 |
atmos4 |
although kasper started devlopment in denmark many years ago |
| 22:45 |
atmos4 |
it's hard to say, but of course typo3 beeing open source is important |
| 22:46 |
atmos4 |
but there's also a large amount of people that deliver services for typo3 in germany |
| 22:46 |
atmos4 |
but why it spread here more than in the us is hard to say |
| 22:46 |
rawtaz |
okay |
| 22:46 |
atmos4 |
maybe the us cms where not well localized |
| 22:46 |
rawtaz |
some secret society made it happen, im sure. |
| 22:47 |
pond |
i have wondered that too from time to time... maybe Kasper's english is fairly natural to a native German speaker? |
| 22:47 |
atmos4 |
and while developers don't care about an english system, clients sure mind |
| 22:47 |
rawtaz |
could be it. but i cant help thinking why it havent spread more to other countries as well. the suggested reason doesnt exclude other countries |
| 22:47 |
atmos4 |
pond: I don't think that's the point |
| 22:48 |
pond |
well.. I still have trouble figuring out the docs from time to time... |
| 22:48 |
atmos4 |
:-) |
| 22:48 |
atmos4 |
I mostly google |
| 22:48 |
atmos4 |
but sometimes I read the source |
| 22:48 |
atmos4 |
usually much too late |
| 22:48 |
pond |
yeah... lol |
| 22:49 |
pond |
I work with a guy that develops for Joomla all the time... |
| 22:49 |
atmos4 |
it's usually much simpler to look at the code, it's no magic after all |
| 22:49 |
pond |
I can't believe he does it, but he says his clients specifiy it... |
| 22:49 |
rawtaz |
actually, german ppl are often good at english |
| 22:49 |
atmos4 |
yea, I looked at joomla initially, before my first typo3 project |
| 22:49 |
atmos4 |
2004 or sth |
| 22:49 |
rawtaz |
compared to what i hear from other countries |
| 22:50 |
pond |
its a mess, but in the US, its the expected OS cms |
| 22:50 |
atmos4 |
and I didn't like it at all |
| 22:50 |
atmos4 |
typo3 was much cleaner somehow |
| 22:50 |
pond |
right, I totally agree |
| 22:50 |
rawtaz |
i have a friend who is very used to joomla and drupal |
| 22:50 |
atmos4 |
I think drupal is going strong today |
| 22:50 |
rawtaz |
i think they start with it because theyre simpler to get running |
| 22:50 |
rawtaz |
yeah indeed |
| 22:50 |
atmos4 |
but I haven't worked with it yet |
| 22:51 |
atmos4 |
typo3 has quite a steep learning curve, which is something that needs to be addressed |
| 22:51 |
pond |
anyway... don't meaan to jump in... its just a question I have wondered about a lot |
| 22:52 |
atmos4 |
it took me about a month to get the hang of it |
| 22:52 |
atmos4 |
with typoscript and stuff like that |
| 22:52 |
rawtaz |
atmos4: i am a beginner with typo3, and i think a big problem is the documentation. now that ive spent a few days with typo im beginning to get it, but the docs havent been all that helpful. there is too many docs/articles with too low quality, or they are hard to find. there is no easy way to pick up a thread and follow a path to learn things, you have to search and search |
| 22:53 |
pond |
wow ^^ that is really true |
| 22:53 |
atmos4 |
rawtaz: it depends on what you wan't to do |
| 22:53 |
atmos4 |
for the basic stuff to develop a site, there is eg modern template buildinmg tutorials |
| 22:53 |
atmos4 |
but I agree the docs are somewhat poorly organized |
| 22:54 |
rawtaz |
atmos4: i think theyve grown into a big bunch that needs some going through :) theyre not horrible luckily :) |
| 22:54 |
atmos4 |
I think for a developer it is a complex system, but for users it's pretty simple to use |
| 22:55 |
atmos4 |
rawtaz: but when you've got the concepts, it's usaully easy to find what you're looking for with a bit of googling |
| 22:55 |
rawtaz |
glad to hear that :) will take you up on it :P |
| 22:56 |
pond |
there are some great lbogs out there too |
| 22:56 |
atmos4 |
and there are the mailinglists |
| 22:56 |
atmos4 |
they're accessible through a newsreader aswell |
| 22:56 |
pond |
I have often thought that a heirarchical TER with comments and ratings would solve MANY difficulties |
| 22:56 |
atmos4 |
so your mailbox doesn't get swamped |
| 22:56 |
atmos4 |
pond: the ter is one big mess |
| 22:57 |
atmos4 |
I mean from the user interface |
| 22:57 |
pond |
its a great idea... just needs some more time finesing it |
| 22:57 |
atmos4 |
it hasn't changed since ages |
| 22:57 |
atmos4 |
I mean it works well for managing extensions |
| 22:57 |
pond |
lol... yeah... hope the flow3 repo is better |
| 22:57 |
atmos4 |
but the website to search ter is mostly useless |
| 22:58 |
rawtaz |
NOW, finally. had to rebuild all my mysql packages lol. but now i can start typo3 with it |
| 22:58 |
pond |
exactly... there is not real feedback or commentary from users... which alone would make it nicer |
| 22:58 |
rawtaz |
the upside is that im getting *really* good at the 123-wizard =P |
| 22:58 |
atmos4 |
rawtaz: you're not using macports? |
| 22:59 |
rawtaz |
atmos4: no, pkgsrc :) its similar to freebsd's ports. its originally for netbsd, but today it covers a lot of platforms, and thats what makes it so nice. plus its good |
| 22:59 |
rawtaz |
ive tried macports and fink and some other thing before.. |
| 22:59 |
atmos4 |
I use macports it works well for me |
| 22:59 |
atmos4 |
fink has limited package availability |
| 23:00 |
atmos4 |
or it had last time is used it |
| 23:00 |
rawtaz |
i can relate to that.. usually the package you need is in $thatOtherPms :p |
| 23:01 |
atmos4 |
if I could choose I'd have the debian package management on mac |
| 23:02 |
rawtaz |
yeah? |
| 23:02 |
rawtaz |
id like freebsd's ports.. |
| 23:02 |
rawtaz |
have you tried both? |
| 23:02 |
atmos4 |
I never seriously used freebsd |
| 23:03 |
atmos4 |
and when I used it I found it to be a major pain compared to linux ;-) |
| 23:03 |
rawtaz |
awww |
| 23:03 |
rawtaz |
it makes me sad to hear that! |
| 23:04 |
atmos4 |
btw. I think macports is not so different from freebsd ports either |
| 23:05 |
rawtaz |
agreed |
| 23:05 |
atmos4 |
but I generally don't like package management that's based on the idea to compile everything on the users system |
| 23:05 |
rawtaz |
ah |
| 23:05 |
atmos4 |
it tends to break dependencies a lot |
| 23:06 |
rawtaz |
but you do know that ports can be used with binary packages as well right? |
| 23:06 |
atmos4 |
and itäs a pain to keep it updated |
| 23:06 |
atmos4 |
eg. with security fixes |
| 23:06 |
rawtaz |
easily too, its just like pkg_ad -i yadapackagename |
| 23:07 |
atmos4 |
eg. with macports you install a new package and it fetches a new version of a library |
| 23:07 |
atmos4 |
than it can happen, that older apps linked to that lib no longer work and you need to recompile them aswell |
| 23:07 |
rawtaz |
mm :) |
| 23:07 |
rawtaz |
thats when you get that all warm and fuzzy feeling :3 |
| 23:07 |
atmos4 |
I mean why bother with compiling, if I just wanna use an application and not modify it |
| 23:08 |
rawtaz |
because in your heart you know you like it ;) |
| 23:08 |
atmos4 |
I sure love apt-get update && apt-get upgrade more |
| 23:08 |
rawtaz |
heh yeah. well i can understand that theres a ncie touch to not having to compile things. as long as the packages contain the options/features you need of course |
| 23:08 |
rawtaz |
what linux do you prefer btw? |
| 23:09 |
atmos4 |
for server debian |
| 23:09 |
rawtaz |
im about to set up a linux server but dont know which dists i prefer. ive used slackware a lot in the old days. now im considering debian mostly i think |
| 23:09 |
rawtaz |
maybe suse |
| 23:09 |
rawtaz |
do you run stable? |
| 23:09 |
atmos4 |
I've used SuSE for some time, but especially on servers it#s a real pain |
| 23:09 |
atmos4 |
yes |
| 23:10 |
rawtaz |
the one and only thing holding me back on debian is that its so long between releases. but theres backports right? |
| 23:10 |
atmos4 |
the upgrade system of suse is not made to allow runtime system upgrade |
| 23:10 |
atmos4 |
which is a major dealbreaker for remote servers |
| 23:10 |
rawtaz |
thats a big point yes |
| 23:10 |
atmos4 |
you can#t just take a webserver out of order to do an upgrade# |
| 23:11 |
rawtaz |
one of the selling ones ive considered regarding debian. that its fool-proof (almost) so that ppl other htan me can d it too ;P |
| 23:11 |
atmos4 |
with debian I just issue an apt-get dist-upgrade and reboot |
| 23:11 |
rawtaz |
atmos4: when you say that about suse you mean SLES right? |
| 23:11 |
atmos4 |
they also have a long release cycle, which is great for servers |
| 23:11 |
atmos4 |
no, suse or opensuse |
| 23:12 |
rawtaz |
but surely there can be times when the added software in the system breaks when you do an upgrade? or does debian automatically upgrade those too? if thats the case then couldnt your apps break due to for example changes in php? |
| 23:12 |
atmos4 |
don't see why I should pay for an enterprise linux when there are so many good free distros out there |
| 23:12 |
rawtaz |
hm isnt SLES and suse the same "thing" ? |
| 23:12 |
rawtaz |
SLES is an enterprise version of suse perhaps |
| 23:12 |
atmos4 |
well it shares the same disadvantages |
| 23:12 |
rawtaz |
ok |
| 23:12 |
atmos4 |
only with sles you have less package availability =) |
| 23:13 |
rawtaz |
haha ok :D |
| 23:13 |
SargoDarya |
SLES = Suse Linux Enterprise System |
| 23:13 |
rawtaz |
its so hard to know all this, in the end you just have to try it yourself. a friend who runs some hosting and stuff is very happy with sles |
| 23:13 |
rawtaz |
thats why i even bothered to think about it |
| 23:13 |
atmos4 |
my current production webserver still runs suse for historic reasons |
| 23:13 |
SargoDarya |
btw. rawtaz could you solve your problem? |
| 23:13 |
rawtaz |
but he does run debian too on a little one :-) |
| 23:14 |
atmos4 |
the first system used suse, then at hardware upgrade it was easier to port the data to new suse system |
| 23:14 |
atmos4 |
because of same directory structures etc |
| 23:14 |
atmos4 |
but it's already outdated again |
| 23:14 |
SargoDarya |
I prefer debian or ubuntu as webserver |
| 23:14 |
rawtaz |
SargoDarya: well a workaround is found but its ugly as hell and not acceptable. the problem is most likely isolated to the fact that i am running against postgresql, i cant get this to happen on a second install against mysql (though it IS a second install so who knows, could be some magical other difference) |
| 23:14 |
atmos4 |
opensuse 10.3 and upgrade is such a pain that it will stay that way for some time |
| 23:15 |
rawtaz |
SargoDarya: i am not sure how to proceed here because i have only vague diagnostics. i have my machine where i can reproduce it but cant really take time to try it on another server and so on |
| 23:15 |
atmos4 |
if I went with a new system now, I'd choose something beefy enough to run a few virtual machines |
| 23:15 |
rawtaz |
i guess one thing would be to have a little chat with someone knowledgable in the DBAL and/or postgres parts, maybe they have a clue right away or at least can let me know what material to provide |
| 23:15 |
rawtaz |
atmos4: as if you dont already have one like that.. :P |
| 23:15 |
atmos4 |
or just order a few vservers and distribute services |
| 23:16 |
atmos4 |
well it's my workstation |
| 23:16 |
atmos4 |
reting such a machine as a server is quite expensive |
| 23:16 |
rawtaz |
yeah |
| 23:17 |
rawtaz |
well since youre into linux why not run KVM? if im not mistaken its not "full" virtualization, so you dont have to spend resources for each machine other than what they use |
| 23:17 |
atmos4 |
I think it makes more sense today to have a fes vservers with dedicated database and mail server etc |
| 23:17 |
rawtaz |
like with freebds's jails |
| 23:17 |
atmos4 |
so you don't have a single point of failure |
| 23:17 |
rawtaz |
yeah indeed |
| 23:17 |
rawtaz |
ive had a webhosting for some years and used jails on it, splitting each service into its own jail. i think its natural to do so |
| 23:17 |
rawtaz |
for security and then you can also tune the various machines more specifically |
| 23:18 |
atmos4 |
the nice thing with vms is you can easily backup the entire system and transfer it to another host |
| 23:18 |
rawtaz |
sure |
| 23:19 |
atmos4 |
I also do system administration and nowadays most cutomers runn 2 big servers + san and have all servers virtualized |
| 23:19 |
rawtaz |
soo, not to ignore you or anything, but is there anyone in here that has to do with the dbal or postgres parts of typo3, that i could talk to? |
| 23:19 |
rawtaz |
not necessarily right now but,, sometime |
| 23:20 |
rawtaz |
ries perhaps? |
| 23:20 |
ries |
raw?? |
| 23:21 |
ries |
@rawtaz |
| 23:21 |
rawtaz |
oh sorry, didnt mean to disturb you :D |
| 23:21 |
atmos4 |
rawtaz: I'd give the mailinglists a shot |
| 23:21 |
ries |
Ahhh PostgreSQL.... I didn't do PG with TYPO3 for a while... but it's get's more stable by the week |
| 23:21 |
rawtaz |
ries: i recall talking with you about postgres, thats why i mentioned you now. i have a reproducable problem/issue when running 4.4 against postgres |
| 23:22 |
rawtaz |
atmos4: maybe i should. could make a small initial post and provide more info along the way |
| 23:22 |
ries |
out of curiosity, did you add the PostgreSQL stored procederes to your DB? |
| 23:22 |
rawtaz |
ries: i have not. i have done a regular install, unpacked+set permissions, then did the 123-wizard, then basic conf in the install tool, then straight into the backend |
| 23:23 |
rawtaz |
ries: are they described somewhere? i must have missed them |
| 23:23 |
ries |
do yopu know at what query it fails? |
| 23:23 |
rawtaz |
ries: no, i cannot see any errors anywhere (checked the php logs, and the logs in the BE). the database logs doesnt say anything bad either when i run the queries |
| 23:24 |
ries |
so it might be a incorrect result returned... |
| 23:24 |
ries |
last tiem I tried it, I could at least login properly |
| 23:25 |
rawtaz |
haha |
| 23:25 |
rawtaz |
yeah thats a good start =) |
| 23:25 |
atmos4 |
yea, but he gets empty list when trying to add new content element through the wizard |
| 23:25 |
rawtaz |
ill make a screenshot |
| 23:25 |
ries |
atmos4: I have seen that b4... |
| 23:26 |
rawtaz |
http://grab.by/5swn |
| 23:26 |
atmos4 |
wrong result could make sense |
| 23:26 |
rawtaz |
its like that every time i try to add a CE, EXCEPT when i have cleared all caches right before i click this button |
| 23:26 |
atmos4 |
but to debug one would have to compare query log of mysql and query log of postgre, or add some debug code |
| 23:27 |
rawtaz |
my usual way of getting to these problems is to just dig into the framework code. i havent gotten there yet though with this one. its more code than usual :) |
| 23:27 |
rawtaz |
its crazy that not more ppl run postgres here. i mean c'mon! :D |
| 23:28 |
rawtaz |
whats wrong with a real db for once :p |
| 23:28 |
atmos4 |
well I don't think there's much difference these days |
| 23:28 |
atmos4 |
I mean with mysql 4.0 there where lots of stuff missing |
| 23:28 |
atmos4 |
but today I think it has most stuff thst's needed |
| 23:29 |
rawtaz |
probably |
| 23:29 |
atmos4 |
and most isn't even used by webapps |
| 23:29 |
rawtaz |
i must admit that some things are much easier to do in mysql than in postgres |
| 23:29 |
atmos4 |
I don't thin typo3 uses a single database view for example =) |
| 23:29 |
rawtaz |
ries: what stored procedures were you thinking about earlier? i get/got hte feeling that there is something i have not done, that should be done during installation |
| 23:30 |
ries |
rawtaz: That's shown when you would install DBAL in a working installation |
| 23:30 |
ries |
let me see if I can find them |
| 23:30 |
tmkd_ |
when i enable cache on my website macina banners and google adsense works great |
| 23:30 |
tmkd_ |
but this is provide more work for server |
| 23:31 |
tmkd_ |
then if i disable cache, adsensse stop displaying |
| 23:31 |
ries |
rawtaz: check typo3/sysext/dbal/res/postgresql |
| 23:31 |
rawtaz |
ries: by working installation, do you mean an existing installation, when you add DBAL because it doesnt already exist? if it makes any difference, dbal is loaded here |
| 23:31 |
tmkd_ |
do you have some ide how to improve that? |
| 23:31 |
rawtaz |
ries: thank you, ill have a look and see if theyre there |
| 23:31 |
ries |
rawtaz: if you would enable DBal if you want to haev shared tables between mysql and postgresql, |
| 23:32 |
ries |
Xavier knows a bit more about the 123 installer, I think it should add the compatibility functions |
| 23:32 |
rawtaz |
ries: but isnt the dbal installed and enabled by default? |
| 23:32 |
ries |
rawtaz: nope |
| 23:32 |
rawtaz |
oh damn.. |
| 23:32 |
rawtaz |
youre right. in my mysql installation i dont have the dbal |
| 23:33 |
rawtaz |
so presumably it is enabled by the installer, when you choose postgres as the db |
| 23:33 |
rawtaz |
because the postgres parts simply uses the DBAL |
| 23:34 |
atmos4 |
I guess there are a lot of extensions, that were never tested with anything else than mysql |
| 23:35 |
rawtaz |
atmos4: yeah.. thats very wise in one way of looking at this |
| 23:36 |
rawtaz |
at the same time we really like postgres, use it for everything else if we have a choice, and now that its part of the installer its that ppl start using it :) |
| 23:36 |
atmos4 |
well I mean if you don't mind fixing extension errors and stuff go for it |
| 23:36 |
rawtaz |
i remember ries saying that there will be a few bumps down the road but if we can just spend a little time on it (and by that i hope he meant a little :P) it should be fine |
| 23:36 |
atmos4 |
but it will cuase you more work |
| 23:37 |
rawtaz |
i wonder how many of the common extensions use mysql functions directly, and not the DBAL (this afaik they should use) |
| 23:37 |
rawtaz |
do you have any idea about that? |
| 23:37 |
ries |
rawtaz: it's always got to have your xdebugger at hand :) |
| 23:37 |
ries |
good |
| 23:37 |
rawtaz |
ries: thats a php extension right? |
| 23:37 |
ries |
yes |
| 23:37 |
atmos4 |
rawtaz: all cleanly written extensions hsould never use direct mysql calls |
| 23:37 |
ries |
debugging with netbeans and xdebug is what I use |
| 23:38 |
atmos4 |
but they might still use sql constructs that don't work |
| 23:38 |
rawtaz |
ries: cool. will install it. can you just sum it up for me, when its installed what do i have to do more to make it aid in debugging typo3 for me? |
| 23:38 |
ries |
atmos, in some situations using MySQL can cause more grieve then anything else.. |
| 23:38 |
atmos4 |
there are different levels of database abstraction |
| 23:38 |
rawtaz |
atmos4: hmm, what type of constructs do you mean? you mean the syntax itself, for queries? |
| 23:38 |
atmos4 |
yes |
| 23:39 |
atmos4 |
or maybe inbuilt functions |
| 23:39 |
rawtaz |
atmos4: i thought the DBAL was a datbase abstraction layer, so you dont write your queries manually |
| 23:39 |
ries |
rawtaz: this is my xdebug config, you need to change the location and IP to suite your needs : http://pastebin.com/uNNSDkXk |
| 23:39 |
rawtaz |
or at least that it fiddles with them so theyd work on various servers |
| 23:40 |
ries |
rawtaz: DBAL is weird, but's it's actually a query re-writer |
| 23:40 |
ries |
so it re-writes a query suitable for a other DB |
| 23:40 |
rawtaz |
oh yeah? sounds good. but atmos4 is of course right in that it wont ALWAYS work :) |
| 23:40 |
ries |
it's tricky, and it will always be tricky |
| 23:40 |
rawtaz |
probably when folks do really custom things that the DBAL doesnt recognize or so, i suppose |
| 23:40 |
rawtaz |
indeed |
| 23:40 |
atmos4 |
rawtaz: http://pastebin.com/bNngk6X3 |
| 23:41 |
atmos4 |
this is one example |
| 23:41 |
rawtaz |
ries: your config is for php.ini, correct? |
| 23:41 |
ries |
the mayor issue os that a lot of people that write SQL queries don't know how other DB's work |
| 23:41 |
atmos4 |
the upper code used typo3 recommended way, but then I needed to update a field without a select, so I had to revert to more basic sql() command |
| 23:41 |
ries |
however, TYPO3 doesn't help you (doesn't have an API) with that aswell, or at least... not good enough for the more advanced queries |
| 23:41 |
ries |
rawtaz: yes, I do have it in xdebug.ini though |
| 23:42 |
atmos4 |
because the dl_count=dl_count+1 doesn't work with the recommended way, cause it thinks it's a string |
| 23:42 |
atmos4 |
so I had to revert to writing the query myself |
| 23:43 |
rawtaz |
ries: to sum it up, or put it in another way, "most ppl think databases == mysql" ;/ |
| 23:43 |
ries |
hahaha yes... unfortunatly.. |
| 23:43 |
ries |
How many times I haven't see SELECT A,B,C FROM tableD GROUP BY A; |
| 23:43 |
atmos4 |
if you're on the web |
| 23:43 |
ries |
and they expect it to work... |
| 23:43 |
atmos4 |
otherwise replace by mssql |
| 23:43 |
rawtaz |
i honeslty think its quite sad that ppl default to mysql. but i guess its its right since its what managed to get into peoples head, its not like postgresql took that step out into the public ) |
| 23:44 |
atmos4 |
and php by .net ;-) |
| 23:44 |
atmos4 |
it's a question of wide distribution |
| 23:45 |
rawtaz |
atmos4: in the example you pasted, whats the crux? mysql specific timestamps? |
| 23:45 |
atmos4 |
there's hardly a webserver out there that doesn't run apache, php, mysql |
| 23:45 |
atmos4 |
unless it comes to high performance sites, where technology changes |
| 23:45 |
atmos4 |
rawtaz: no, I try to set column dl_count to dl_count+1 |
| 23:46 |
atmos4 |
thus refererencing the original column name |
| 23:46 |
rawtaz |
ah, and referencing like that isnt ok in postgres? |
| 23:46 |
atmos4 |
but because typo3 things it's a string it will add quotes |
| 23:46 |
rawtaz |
ok |
| 23:47 |
rawtaz |
ries: what about "SELECT A,B,C FROM tableD GROUP BY A;" ? |
| 23:47 |
atmos4 |
that can be done with standard api |
| 23:47 |
ries |
rawtaz: that would not work in PostgreSQL... |
| 23:47 |
ries |
you see similar queries in MySQL, but they won't work on PG or possible other databases |
| 23:48 |
rawtaz |
what is it that wouldnt work in pg? |
| 23:48 |
rawtaz |
i must be blind today :) |
| 23:49 |
ries |
you get errors something like : "ERROR: column "tabled.a" must appear in the GROUP BY clause or be used in an aggregate function" |
| 23:50 |
rawtaz |
eh |
| 23:50 |
rawtaz |
ok |
| 23:50 |
rawtaz |
well i think its time to head home. i guess ill make a post about this on sunday |
| 23:51 |
rawtaz |
thanks for your help guys, its been an interesting discussion |
| 23:51 |
ries |
direct it to Xavier... he is your main guy |
| 23:51 |
rawtaz |
and more activity in this chan than the last week or so :P |
| 23:51 |
rawtaz |
ries: do you recommend i post to a list or to him in here? |
| 23:51 |
ries |
to the list |
| 23:51 |
ries |
typo3-dev |
| 23:51 |
atmos4 |
btw. how are fe_user session variables tracked? |
| 23:51 |
atmos4 |
does it use the fe_user cookie? |
| 23:51 |
ries |
yes |
| 23:52 |
pond |
for real activity here you have to be on about 12 hours ago... or 6 hours ahead |
| 23:52 |
rawtaz |
ries: thanks |
| 23:52 |
atmos4 |
ok, because I'm looking for a way to track access in an eID script |
| 23:52 |
atmos4 |
and because the page access rules cannot work, I'll just use a session id save as session variable |
| 23:53 |
atmos4 |
the pi1 script will post a form to a hidden iframe, so no need to init the whole frontend to mdisplay nothing =) |
| 23:54 |
atmos4 |
such hacks needed to implement upload progress |
