Lots of MySQL errors... when trying to make changes. - Joomla! Forum - community, help and support

-

hi,

i have been using joomla while, , when boss asked me add internal portal site our comapny, had guys in mind.  server i'm operating on windows 2003 server running iis, , latest versions of ph , mysql.

now had working perfectly... had found time install smf bridge , custom login. had working perfectly, until 1 day, went make changes , nothing connect database.

so went in restarted mysql server, , ... database gone ... ??

no biggie, must have happened, , i'm not 1 admin rights, may have tampered it. ... thought myself.

so backed images had done (i had been creating custom theme), , downloaded fresh copy of , reinstalled.

everything installed okay. went redo smf bridge , kept getting error: don't have quote, said param's not wanting take null value. used pma make params take null value. got this:

db function failed error number 1264
out of range value adjusted column 'id' @ row 1 sql=insert core_components values( '', 'phpbb', 'option=com_forum', 0, 0, 'option=com_forum', 'phpbb', 'com_forum', 0, 'js/themeoffice/component.png', 0, '' )
sql =

insert core_components
values( '', 'phpbb', 'option=com_forum', 0, 0, 'option=com_forum', 'phpbb', 'com_forum', 0, 'js/themeoffice/component.png', 0, '' )

so reinstalled joomla, 3 different times, 2 of downloaded fresh copy, make sure there no corruption. i'm thinking, there must wrong bridge now, want else going, strated working on other stuff.

i can't add menu items, can't add components, can change themes, it. can't add users, etc.

i'm getting errors like:
image

its can't write db.  have double checked passwords , looks correct.  can take these sql calls, , copy , paste them pma, , after couple of value changes, it'll work.

i have google'd this, , been scouring forums, , can't find info error this.  can give me tips?

thanks, appreciated.

if need more info me, feel free ask, said, have been doing quite while now.

i readiong thread:
http://forum.joomla.org/index.php/topic,50486.0.html

about error.

but mine working @ 1 time.  thing changed joomla reinstall.....  ???





Comments

Post a Comment

Popular posts from this blog

Thread: PKI Client 5.00 install (for eToken Pro)

-
my company uses aladdin etoken pro authentication on vpn connections. etoken requires pki client application on client machine before os recognize it. app , token work fine on xp, use ubuntu on laptop. aladdin has offered linux version of client, rpm. convinced our internal guys rpms, , i've been trying work couple days. begin with, hp pavilion dv4-1435dx laptop running jaunty 64-bit. - started out converting .rpm .deb using alien: code: sudo alien -d pkiclient-5.00.28-0.x86_64.rpm - worked fine , got nice little .deb - next, ran .deb install client: code: sudo dpkg -i pkiclient_5.00.28-1_amd64.deb - , executed without errors/issues. pdf rpm said there should launcher @ applications > etoken > start etoken pki client, didn't exist. figured might because installed deb instead of rpm. bounced box, still wasn't there. no big deal... - install network manager can configure vpn connection use token: code: sudo aptit...
Read more

ATmega2560-Arduino Pin Mapping

-
hi community, in last days working on project using arduino mega 2560. on planning pin using found bugs in atmega2560-arduino pin mapping . if right there labels (such pwm) in 'mapped pin name' @ wrong row ( mixed pin numbers right one...) in attachment openoffice calc , pdf file corrected table. ( hope ;-) ) i post here tab separated table : code: [select] arduino mega 2560 pin mapping table atmega 2560 pin out arduino mega function nr name function function function mapped pin name function function datasheet 1 pg5 oc0b digital pin 04 pwm 2 pe0 rxd0 pcint8 digital pin 00 rx0 (usart0 receive pin, programming data input or pin change interrupt 8) 3 pe1 txd0 digital pin 01 tx0 (usart0 transmit pin or programming data output) 4 pe2 xck0 ain0 (usart0 external clock  input/output) 5 pe3 oc3a ain1 digital pin 05 pwm 6 pe4 ...
Read more

Crossfader Arduino Tutorial

-
hello i'm super newb please don't bash me much. i'm using led's , i've connected them correctly (finally) , wondering why program here ( http://www.arduino.cc/en/tutorial/colorcrossfader ) doesn't work? say's haven't declared crossfade. read directions on top , said crossfade needs used list order of colors. isn't declared in main part (void loop() )? or need declared before? nevermind void on bottom , needed before voidloop. lol anyways playing rgb led's wondering if has specific way of making them fade in , out different colors? (brightness , color mixing) code: [select] /* * code cross-fading 3 leds, red, green , blue (rgb) * create fades, need 2 things: *  1. describe colors want displayed *  2. list order want them fade in * * describing color: * color array of 3 percentages, 0-100, *  controlling red, green , blue leds * * red red led @ full, blue , green off *   int red = { 100, 0, 0 } * dim white 3 l...
Read more