| 00:19 |
anarkim |
hi people! have you seen a fix to the problem, where the install tool will not go beyond step 2, because a list of databases do not show up (and i can't create a new, because of webhost setup)? |
| 00:20 |
anarkim |
i've looked around and seen this problem around for some time, but haven't yet found a fix... |
| 00:20 |
anarkim |
only option is "select database" |
| 00:21 |
anarkim |
i've tried with both typo3 version 4.2.0 and 4.1.6 |
| 00:24 |
mac3 |
seems you dont have the rights to create a database |
| 00:25 |
mac3 |
you could try to create a database manually |
| 00:25 |
mac3 |
also add a user, who has rights for this database |
| 00:25 |
mac3 |
then use those account for step 1 of the installer |
| 00:26 |
mac3 |
ah sorry |
| 00:26 |
mac3 |
overread (and i can't create a new, because of webhost setup) |
| 00:26 |
mac3 |
;\ |
| 00:26 |
anarkim |
php is 5.2.5, mysql is 5.0.32 |
| 00:26 |
anarkim |
i have a database setup with the account, and its working |
| 00:26 |
mac3 |
are there no items in "select database" ? |
| 00:27 |
anarkim |
no - thats the weird part |
| 00:27 |
mac3 |
maybe write a .php script which tries to setup a connection to the database |
| 00:27 |
mac3 |
then you know for sure |
| 00:29 |
anarkim |
hmm, ok |
| 00:45 |
Denyerec |
Mmm |
| 00:45 |
Denyerec |
Seems like more people are having database related issues with 4.2 |
| 01:01 |
anarkim |
well, in this casealso with 4.1.6 ... so right now i'm trying to edit the /typo3/sysext/install/mod/class.tx_install.php |
| 01:13 |
mac3 |
did you check if you can connect with a simple mysql_connect call? |
| 01:16 |
Denyerec |
you are not alone, 4.2 gave me install grief |
| 01:16 |
Denyerec |
had to have ALTER privs in mysql for it to work for some reason |
| 01:18 |
anarkim |
mac3> the install tool reports that it has connected succefully with the database... |
| 01:19 |
anarkim |
don't know how to check, will digg for it now (first attempt didn't report anything) |
| 01:23 |
anarkim |
ok: mysql_connect - reports success |
| 01:24 |
anarkim |
so db is up and runnig and user/pass works |
| 01:45 |
mac3 |
then try mysql_select_db |
| 01:46 |
mac3 |
if this works, you can access the database |
| 01:55 |
anarkim |
sorry, it connects and selects the database from a singular php script using mysql_connect and mysql_select_db, but the typo3 install tool does not allow me to select the database so that i can install (but thanks for the tips to at least get verification, that all connects... :) |
| 02:07 |
mac3 |
yo np |
| 02:08 |
mac3 |
weird though |
| 02:08 |
mac3 |
ah, one thing |
| 02:08 |
mac3 |
maybe that the functions dont return an error |
| 02:08 |
mac3 |
you could check mysql_error |
| 02:08 |
mac3 |
if there was an error |
| 02:12 |
anarkim |
i set up the script to echo succes and report if 'die' - so i think i have to figure out some workaround in the install tool ... |
| 02:12 |
anarkim |
i think it's the ISP setup which causes this... it's hosted on one.com, so ... |
| 02:15 |
mac3 |
kk |
| 02:29 |
anarkim |
does anybody know/think if it can related to UTF settings between typo3 and mysql? |
| 02:32 |
anarkim |
grasping at straws :) |
| 02:34 |
anarkim |
ok i'm beat for the day - happy hacking everybody! |
| 02:35 |
anarkim |
thanks for the input mac3 |
| 05:00 |
FoBunko |
hi... |
| 11:12 |
null__ |
hi |
| 11:34 |
Awillys |
hi there |
| 11:34 |
Awillys |
anyone using the extension single_signon ? |
| 13:05 |
foool |
I am getting a javescript error in EXplorer, how do I troubleshhoot sometihng like that. it is to do with drop down sitemap. |
| 13:07 |
kozy |
firebug and firefox |
| 13:09 |
foool |
got cut off did anyone answer my question? |
| 13:10 |
kozy |
yes, use firebug and firefox |
| 13:12 |
foool |
never used it before. I will use it and look for a tutorial |
| 13:13 |
kozy |
it's easy, just try |
| 13:14 |
foool |
It diesn't say error or anything like that, should it? |
| 13:26 |
nd_ |
foool: If it's activated, it should |
| 13:52 |
toka1 |
hi |
| 13:52 |
toka1 |
why doesn't it work? |
| 13:52 |
toka1 |
1 = TMENU |
| 13:52 |
toka1 |
1.NO = 1 |
| 13:52 |
toka1 |
#1.NO,linkWrap = | | |*| | |*| | |
| 13:52 |
toka1 |
1.NO.linkWrap = | | |*| | |*| | |
| 13:52 |
toka1 |
the wild cut does not work |
| 13:53 |
toka1 |
the |*| |*| |
| 14:04 |
toka1 |
the line with the # I have from a book it is logic for me |
| 14:04 |
toka1 |
the other line |
| 14:04 |
toka1 |
I just found by testing all |
| 14:04 |
toka1 |
it is unlogic |
| 14:04 |
toka1 |
but the unlogic one works |
| 14:04 |
toka1 |
#1.NO,linkWrap = | | |*| | |*| | |
| 14:04 |
toka1 |
1.NO.linkWrap = || | |*| | | |
| 14:07 |
kozy |
I think something is wrong with the configuration of the templavoila mailinglist. I get my mail back with a message there was a loop. |
| 14:07 |
kozy |
I've mailed the list administrator but I get no response |
| 14:08 |
kozy |
so if anybody here has the possibility to take a look? |
| 14:24 |
anarkim |
hi people! i have an annoying problem with a typo3 installation. the install tool will not go beyond step 2, because it does not retrieve a list of databases from the server. i've checked with mysql_connect and mysql_select_db, that database is up and running and connection can be made. typo3 install will not... any ideas how to fix this? could it be related to character encoding issues... |
| 14:24 |
anarkim |
...between typo3 and mysql??? |
| 14:26 |
Denyerec |
mmm |
| 14:26 |
Denyerec |
You have an existing blank DB |
| 14:26 |
Denyerec |
and it doesn't list it? |
| 14:27 |
anarkim |
yes |
| 14:27 |
anarkim |
yes |
| 14:27 |
Denyerec |
My guess would be your localconf.php wasn't written so the DB connection details are not there / incorrect |
| 14:27 |
anarkim |
from phpwebadmin i can access and play around with it |
| 14:27 |
Denyerec |
manually add your DB login details to /typo3conf/localconf.php |
| 14:27 |
Denyerec |
and try again |
| 14:28 |
anarkim |
no i do't think so, because if i leave 1-2-3 and go to detailed mode, the connection is reported as OK - but i still can't choose a database |
| 14:28 |
anarkim |
ok i'll try manual edit of /typo3conf/localconf.php |
| 14:29 |
anarkim |
but i would really like to manually override the 1-2-3 and just chosse the database ... where is that done? |
| 14:29 |
anarkim |
also in /typo3conf/localconf.php? |
| 14:29 |
Denyerec |
Yeah |
| 14:29 |
Denyerec |
Um |
| 14:29 |
Denyerec |
does the 123 installer give you the option to crate a new one? |
| 14:29 |
Denyerec |
if so, just do that. |
| 14:30 |
anarkim |
no it doesn't (barred from ISP...) |
| 14:40 |
anarkim |
WHOPPIE!!! :-) manual overide in the /typo3conf/localconf.php worked!just inserted my best guess $typo_db = 'NAME OF DB FROM ISP'; |
| 14:41 |
anarkim |
thanks Denyerec!!! |
| 14:42 |
anarkim |
yesterday i was working on the wrong file&dir |
| 14:45 |
anarkim |
oh happy day / finally got beyond the installer! now the real fun begins :-) |
| 17:20 |
j_s |
just2b, thank you for the tips yesterday regarding image handling from a frontend extension. I ended up using the getUniqueName() and upload_copy_move()-functions combined with the cObj->IMG_RESOURCE()-function for resizing when viewed. |
| 19:22 |
kraftb |
hiho .... |
| 19:29 |
Awillys |
heya |
| 19:29 |
Awillys |
kraftb: you know that extension you made long time ago. the one that would automate some task, like creation of page, folder etc... |
| 19:32 |
Awillys |
btw, is upgrade from typo 3 v4.6 to v4.2 safe? i mean is there any know issues with some extensions? |
| 19:32 |
kraftb |
hi awillys ... |
| 19:33 |
kraftb |
yeah ... i remember the extension ... |
| 19:33 |
kraftb |
kb_taskc_auto |
| 19:33 |
kraftb |
but I currently do not know where it is :) |
| 19:33 |
kraftb |
probably somewhere on my server ... but hey ... |
| 19:33 |
Awillys |
roflol ^^ i told you that you should have sent me a copy ^^ |
| 19:33 |
kraftb |
i attended todays "vienna city marathon" ... and are quite tired now |
| 19:33 |
kraftb |
and have a muscle pain on all two upper legs :) |
| 19:33 |
Awillys |
hehe |
| 19:33 |
kraftb |
you sent me a mail ? |
| 19:34 |
kraftb |
when ? |
| 19:34 |
Awillys |
long time ago, 2 years |
| 19:34 |
kraftb |
if it's in my inbox i am going to have a look during the next days .... |
| 19:34 |
Awillys |
lol |
| 19:34 |
kraftb |
oh ... |
| 19:34 |
kraftb |
ok ... |
| 19:34 |
kraftb |
i assume it is at least installed at the website of my earlier employer .... |
| 19:34 |
kraftb |
at one of them ... if they didn't a new setup |
| 19:35 |
Awillys |
I am working on a community site, registered users should have their own set of pages, fupload forlder for picture or file upload |
| 19:36 |
Awillys |
i am wondering if smthg similar to that extension of yours is needed or if it can all be done differently |
| 19:37 |
kraftb |
the problem with custom upload folder for each user is that you can't set "uploadDir" in TCA ... |
| 19:37 |
kraftb |
probably by some userFunc ... executed before saving to TCE is done |
| 19:37 |
kraftb |
but then you would also need to create a hook for t3lin_tceforms ... |
| 19:38 |
kraftb |
so when viewing a user record that the correct path is also set in BE |
| 19:38 |
Awillys |
i see |
| 19:38 |
Awillys |
well is it possible then to just customize file name with user name as prefix to make it easier to recognise user specific files? |
| 19:52 |
Awillys |
hum |
| 19:52 |
Awillys |
kraftb: still around? |
| 19:52 |
Awillys |
did they fix that TS template saving thing? |
| 19:52 |
Awillys |
in 4.2 |
| 19:57 |
kraftb |
awk |
| 19:57 |
kraftb |
awillys: which extenion do you use to create / edit FE user records and associated data ? |
| 19:57 |
Awillys |
t3editor |
| 19:57 |
kraftb |
which template saving thing ? |
| 19:57 |
Awillys |
oups |
| 19:58 |
Awillys |
in 4.2 when i save ts it does not save |
| 19:59 |
Awillys |
kraftb: sr_feuser_register |
| 19:59 |
Awillys |
hum i got a lot of questions today ^^ |
| 20:00 |
Awillys |
Anyone using a single signon ext? i need fe_users of new website to use their username/pass from another site (different severs..) |
| 20:01 |
kraftb |
is sr_feuser_register supports having auserFunc / hook before saving this is done relative quickly |
| 20:01 |
kraftb |
... just change uploadDir in TCA before saving and create t3lib_tceforms hook ... |
| 20:02 |
kraftb |
no gurantee it will work that easily ... prefix for filename is surely faster ... |
| 20:04 |
Awillys |
k, cheers |
| 20:05 |
Awillys |
any clue for the fe_users data sharing between several t3 installs? with eventually different servers |
| 20:09 |
ries |
Awillys: You could use DBAL to point all fe tables to one installation |
| 20:09 |
ries |
hey kraftb what have you been up to lately? |
| 20:09 |
kraftb |
hi ries ... |
| 20:09 |
kraftb |
well ... mostly two projects .... |
| 20:10 |
kraftb |
www.sicher-auf-reisen.at |
| 20:10 |
kraftb |
and www.baby-party.at ... but sadly both for a company which is not wanting to make a note on my company on those sites |
| 20:10 |
kraftb |
(mmc is the company) |
| 20:10 |
ries |
well... that happens... |
| 20:11 |
Denyerec |
kraftb! |
| 20:11 |
ries |
I never ask that actually :) |
| 20:13 |
kraftb |
http://www.vienna-marathon.com/?url=result&wantResult=2008&marathon=name&art=startnummer&button=mara&test=0&nummer=2668 |
| 20:14 |
kraftb |
well ... but they pay quite good |
| 20:14 |
ries |
isn't that most important? |
| 20:15 |
kraftb |
hmm ... sometimes yes ... sometimes not .. |
| 20:16 |
ries |
ofcourse... |
| 20:17 |
ries |
But I rather have a high payed job without my name... then a low payed with... |
| 20:57 |
FoBunko |
yo, wuzz goin |
| 22:01 |
void |
ries: do you know that you are being quoted? |
| 22:02 |
void |
>As Ries van Twisk would say: Popcorn ! |
| 22:02 |
ries |
void: popcorn :D |
| 22:02 |
void |
=) |
| 22:02 |
void |
sic come on gloria mundi? =) |
| 22:04 |
ries |
void: it's somethign between me and Patrick |
| 23:10 |
I---^I |
hello |
| 23:10 |
I---^I |
I'm getting errors like "mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/localhost/htdocs/typo3/t3lib/class.t3lib_db.php" |
| 23:11 |
I---^I |
on simple operations such as "list" view |
| 23:11 |
Phlogi |
what did you do beofre tha? |
| 23:11 |
I---^I |
in t3 4.2.0 with mysql 5 |
| 23:11 |
I---^I |
nothing |
| 23:11 |
Phlogi |
maybe you installed some bad extension |
| 23:11 |
Phlogi |
update? |
| 23:11 |
I---^I |
it's a pretty clean t3 installation |
| 23:11 |
I---^I |
nopw |
| 23:11 |
Phlogi |
Check the install tool and compare there |
| 23:12 |
I---^I |
actually, it did this when it was completely clean |
| 23:12 |
I---^I |
where should I check it Phlogi? |
| 23:13 |
void |
I---^I: set sqlDebug to 1 at yours intall tool |
| 23:13 |
void |
then, sql errors should become visible |
| 23:14 |
I---^I |
yes |
| 23:14 |
Phlogi |
in the install tool go to database and then run compare... |
| 23:14 |
Phlogi |
is it a fresh 4,2 installation? |
| 23:14 |
Phlogi |
hi void |
| 23:14 |
void |
I---^I: and what is that error? |
| 23:17 |
I---^I |
in compare, no errors, only Extra tables in the database, in (static_tsconfig_help and tx_impexp_presets) |
| 23:18 |
I---^I |
however, when I go to list, then click on the root, I get (with the debug) |
| 23:18 |
I---^I |
er t3lib_DB::exec_SELECTquery ERROR Unknown column 'pid' in 'where clause' lastBuiltQuery SELECT count(*) FROM tt_news WHERE pid=0 |
| 23:18 |
I---^I |
debug_backtrace SC_db_list->main#451 // recordList->generateList#295 // localRecordList->getTable#268 // recordList->setTotalItems#387 // t3lib_DB->exec_SELECTquery#490 // t3lib_DB->debug#234 |
| 23:18 |
I---^I |
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/localhost/htdocs/typo3/t3lib/class.t3lib_db.php on line 822 |
| 23:19 |
I---^I |
it's a shitload more, but that's what seems to be the important part |
| 23:19 |
I---^I |
Ah, I think i know a think |
| 23:19 |
I---^I |
g |
| 23:19 |
I---^I |
when installing TIMTAB, do I need to install ve_guestbook and the other thing manually? |
| 23:20 |
I---^I |
and tt_news or whatever it's called? |
| 23:21 |
I---^I |
it's a fresh "dummy" installation. Only extensions I installed are ITMTAB, TemplaVoila and the tutorial package doc_tut_templselect2 |
| 23:28 |
void |
I---^I: seems that you don't have 'pid' field at tt_news table, which is required. check that your mysql user can ALTER tables |
| 23:28 |
I---^I |
well, I had some issues with that |
| 23:28 |
I---^I |
the user t3 is running from has alter rights on the t3 table |
| 23:28 |
I---^I |
however it doesn't seem to work |
| 23:28 |
I---^I |
I checked this with Denyerec |
| 23:29 |
I---^I |
even submitted a bug report for it |
| 23:29 |
Denyerec |
I wonder what the sudden requirement for ALTER s |
| 23:29 |
Denyerec |
*is |
| 23:29 |
void |
I---^I: try to add that field manually with phpmyadmin.. i |
| 23:29 |
FoBunko |
I you use mysql5 ? |
| 23:29 |
I---^I |
void: do I need to install tt_news and ve_guestbook manually before installing TIMTAB? |
| 23:29 |
I---^I |
yep |
| 23:30 |
I---^I |
and realurl? |
| 23:30 |
FoBunko |
have you set mysql mode to mysql4 ? |
| 23:30 |
void |
as far as i know, timtab requires you to install tt_news and ve_guestbook |
| 23:31 |
I---^I |
that might explain the missing fields :-P |
| 23:31 |
void |
because timtab itself is just 2 classes which use those extensions |
| 23:35 |
I---^I |
ok |
| 23:36 |
I---^I |
I think installing timtab first then those two seriously b0rked things around here ... |
| 23:38 |
I---^I |
I think I'll do a little reinstall tomorrow |
| 23:38 |
I---^I |
then I can do the "drop table"... Yee ! |
| 23:39 |
I---^I |
thanks for the help anyway! |
| 23:39 |
I---^I |
bye |
