No wlan0 interface after uninstall Ubuntu 13.04

Question

I used the following script to populate a table. This script worked just fine:

insert into TSC_Intermediate.dbo.stock 
                (article
                , description
                , article_id
                , client
                , available_stock
                , unit
                , location
                , warehouse)
        select a.article
            , b.art_descr
            , a.article_id
            , a.client
            , a.value_1
            , a.unit_code
            , a.location
            , a.warehouse
        from aststock a
            join
                algarticle b 
            on a.client = b.client 
                and a.article = b.article 
        where a.client = 'cp'

Now what I need to do is continue to run that script but have it update available_stock when there is a duplicate key, and insert new rows when there is not. The key is on (article, location, warehouse)

I believe I need to use the code: ON DUPLICATE KEY UPDATE 'available_stock'

I'm missing something though. The other questions that I can see on this topic involve only adding 1 or 2 lines, so they specify what values to update. I'm confused as to how to make this work. Also, when I start typing ON DUPLICATE at the end of that code, SQL gives me a squiggly line under the ON, indicating that I'm putting it in the wrong place.

Solution

Basically, this sounds like drivers/modules problems. You can use the following to determine which module is associated to your wireless component :

lspci -vvnn

Load this module :

modprobe [module name]

You can set loaded-on-boot modules in /etc/modules. Add your wireless module to this file, and reboot.

Concerning drivers, have a look here : http://wireless.kernel.org/en/users/Drivers/iwlwifi

Comments

[Yeung]

Thanks. For module, I don't know about it. You give me hint for search about iwlwifi. I found this helped me (but replace compat-wireless to backports)

[Bondurant]

I run lspci -vvnn but I do not guess which module is associated to the wireless component. Which line specifies this information ?

[John WH Smith]

Search for words like "Wireless", "Network adapter", but avoid "Ethernet". Then, look at the line "Kernel modules" under it.

[Heberto Mayorquin]

I got the following associated to wireless: 3a:00.0 Network controller [0280]: Intel Corporation Wireless 8260 [8086:24f3] (rev 3a) Subsystem: Intel Corporation Device [8086:0050] Control: I/O- Mem- BusMaster- SpecCycle- MemWINV- VGASnoop- ParErr- Stepping- SERR- FastB2B- DisINTx- Status: Cap+ 66MHz- UDF- FastB2B- ParErr- DEVSEL=fast >TAbort- <TAbort- <MAbort- >SERR- <PERR- INTx- Interrupt: pin A routed to IRQ 255 Region 0: Memory at dc200000 (64-bit, non-prefetchable) [disabled] [size=8K] Capabilities: <access denied> But did not find "kernel modules"